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
I was hoping you could assist me with a similar problem? My spread sheet has membership dates in one column and expiry dates in the adjoining, I had it set up so if the exoiry dates were exceeded, the cells high lighted with a red fill. This no longer seems to be working, could you help me please? Nauthstar
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.
- done, thank you.
Please go here https://techcommunity.microsoft.com/t5/Excel/bd-p/ExcelGeneral and click on Start new conversation
- Apologies, I am new to the community thing. How do I start a new conversation?