Aug 22 2022 08:24 PM - edited Aug 22 2022 10:33 PM
I am creating a spreadsheet for vehicle registration and I would like the cell color to change when it is nearing expiry. Is this possible? Thanks in advance
- Cell color RED if date in cell is today's date or older
- Cell color ORANGE if date in cell is between tomorrow's date and 1 months time
- Cell color GREEN if date in cell is more than 1 month from today
Aug 22 2022 10:37 PM - edited Aug 22 2022 10:38 PM
@user1234321 You need 3 conditional formatting rule. See attached file.
For red =A2<=TODAY()
For orange =AND(A2-TODAY()>=1,A2-TODAY()<=31)
For green =A2-TODAY()>31
Aug 22 2022 10:40 PM
How To Conditional Formatting Based On Date In Excel?
Hope I could help you with these information / link.
I know I don't know anything (Socrates)
Aug 22 2022 10:46 PM
SolutionAug 22 2022 10:56 PM
Aug 22 2022 11:17 PM - edited Aug 22 2022 11:18 PM
I am working with Google sheets - when I add the custom formula to Conditional format rules it applies A2 only
Aug 22 2022 11:35 PM
Aug 22 2022 11:46 PM
Aug 23 2022 01:59 AM
Aug 23 2022 04:28 AM - edited Aug 23 2022 04:29 AM
It does help, thank you for that.
I have a date that should be orange but instead it is white. Any idea's why the orange is not taking effect?
Aug 23 2022 07:12 AM
Aug 23 2022 04:08 PM - edited Aug 23 2022 04:09 PM
@Harun24HR
The green is working thank you, however if it meets the value of Orange it changes to white
Aug 23 2022 04:43 PM
Aug 22 2022 10:46 PM
Solution