I have an excel spreadsheet with a project schedule in it.
I color the cells in rows for each task.
I have a task that is dependent upon another task finishing by a certain date.
I use this formula in conditional formatting to color successive cells in a row showing the delay caused by a task not being completed.
=$O$12>6
This is the formula for the first cell.
The formula for the next cell in the row would be: =$O$12>6+1 and then each cell thereafter increments by 1: =$O$12>6+2,...+3,... etc.
Is there a faster way to do the conditional formatting in each cell without having to put a new formula in each cell?