Forum Discussion
Solved
Conditional Formatting
Can anyone do some conditional formatting on the attached document... I need expired dates to turn red, any dates within 30 days to turn yellow, and all other dates to turn green. I have trie...
Hi, I have changed it so that ALL records less than today (+ optional n) shows as RED.
Kind regards
That's a separate topic, better if you start new conversation.
As for the file, you highlight dates which are in this and previous months (Aug and Jul) of the current year - there are no such dates.
Apologies, I am new to the community thing. How do I start a new conversation?
- done, thank you.
Please go here https://techcommunity.microsoft.com/t5/Excel/bd-p/ExcelGeneral and click on Start new conversation