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?
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.
- It does change colour however is using A2 value, not A3, A4 etc. All cells end up being the same colour
- The image shows A1,A17. That is A1 and A17, not A1 to A17. The range is written A1:A17.
I hope that helps.
