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
How to empower people to use Copilot?
Rolling out copilot isn’t something you do to people; it’s something you do with them.
Copilot
Why Everyone Is Talking About Copilot Cowork
Most of us have used Copilot Chat. We've asked it to summarise documents, draft emails, answer questions, or help us brainstorm ideas. It's useful. If you could stop asking AI to help with work and start asking it to do work?
That's the promise of Copilot Cowork and it could fundamentally change the way we work.
365 Productivity
The wrong email address keeping appearing in Outlook?
How to stop the incorrect email address showing up when entering a name.