@excelerateau: Hook your audience with a quick fix for better rosters! Did you know you can highlight public holidays automatically in your employee roster template? In this video, we show how to use =ISNUMBER(MATCH(F$4,$AT$5:$AT$28,0)) to colour the holiday dates, keeping your schedule clear and compliant. Pair this tip with our 4‑week roster template to manage shifts, leave and payroll effortlessly. Save this and try it on your own schedule! #excel #exceltutorial #rosterTemplate #spreadsheet #exceltips

excelerateau

Open In TikTok:

Region: AU

Thursday 02 July 2026 02:46:00 GMT