Forum Discussion
Solved
Cell color changes when registration date nearing expiry?
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
- Thankyou for this, much appreciated.
Can I duplicate these rules to other cells without manually changing A2 to the new cell, eg A3?
How To Conditional Formatting Based On Date In Excel?
- equal to today:=$B2=TODAY()
- reater than today: =$B2>TODAY()
- Older than today: =$B2<TODAY()
Hope I could help you with these information / link.
I know I don't know anything (Socrates)
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- Thankyou for this, much appreciated.
Can I duplicate these rules to other cells without manually changing A2 to the new cell, eg A3?- You do not need to duplicate the rules. It will automatically apply to all cells given to Applies To range.
