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?
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?
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.
I am working with Google sheets - when I add the custom formula to Conditional format rules it applies A2 only
- Your image would suggest that you have been successful in applying the conditional format to cells A2 and A17. I would, however, suggest that you are sparing with your use of colour. It is difficult to read text against a dark colour and overuse reduces its impact.
