Excel Conditional Formatting Dates
Start by selecting a column of dates.
Click conditional formatting.
Highlight Cell Rules.
Click A Date Occurring.
Now choose your Date Occurring and Format Colour.
Keen to stay up to date on anything 365?
Sign up for tips and updates
You may also like
Copilot
Those App Icons in Copilot Actually Mean? (And Why It Matters for Your Team)
Have you or someone in your team opened Copilot and wondered what all those app icons actually mean?
Teams
How to Create a Quick Poll on Teams
Use a Poll in a Conversation to find out answers for quick survey questions on Teams.
365 Productivity
Still deleting emails one by one? Try Sweep in the New Outlook.
If your inbox is overflowing with notifications, and automated messages, there's a built-in feature in the New Outlook that can help.