Forum Discussion
IF statements and conditional formatting
I have conditional formatting set to change the colour of the cell when it becomes overdue based on todays date. it is green whilst in date, and then red once over due. I want it to change to ano...
I have tweaked the formulas in column F, H and J and used formulas to make new rules for conditional formatting for these columns.
Please refer to the attached for more details.