J
JayM
I have put some conditional formatting on columns in a spreadsheet as folows:
Cell Value is less than =TODAY() - format cell to Red
Cell Value is less than =TODAY()+30 - format cell to Orange
Cell Value is greater than =TODAY() - format cell to Green
But I now want to say if the cell is blank to leave it with no colour
Any help would be greatly appreciated.
JayM
Cell Value is less than =TODAY() - format cell to Red
Cell Value is less than =TODAY()+30 - format cell to Orange
Cell Value is greater than =TODAY() - format cell to Green
But I now want to say if the cell is blank to leave it with no colour
Any help would be greatly appreciated.
JayM