Forum Discussion
Conditional Formatting on whole column with variable reference cells
Hi, I'd like to format the colour fill of multiple cells within one particular column, when it's value is less than a cell in the row above of the next column. how should I do this please? eg....
LShoesmith When I've done this before, I created a separate column to indicate that a task was completed. I then created an IF statement based on that completion column to indicate if the task was Done or the # of days remaining before it was due. For cell values that Contain 'Done', conditional formatting turns that green. The yellow and red conditions apply as normal.
Screenshot from file I use
