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 ...
- 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)