downunder400
New Member
- Joined
- Aug 24, 2020
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
Hi,
I'm trying to activate conditional formatting to an excel sheet so when a date hits 60 days before expiry highlight it yellow, when it hits 30 days highlight it orange and when it expires highlight it red.
Is this possible and if so how?!
Thanks
I'm trying to activate conditional formatting to an excel sheet so when a date hits 60 days before expiry highlight it yellow, when it hits 30 days highlight it orange and when it expires highlight it red.
Is this possible and if so how?!
Thanks