automatically incrementing a conditional formatting

[PMAl]

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?

[martindwilson]

=$o$12>6+rows($a$1:a1)-1

[PMAl]

Thanks for your suggestion.
I should clarify a little. The subsequent cells will only highlight as the reference task is delayed by another day.
Cell o13 colors after a delay of a day.
Cell o14 colors after a delay of a 2nd day, o13 stays colored.
Cell o15 colors after a delay of a 3rd day, o13, o14 stay colored, etc.

The formula you gave me causes all of the cells to highlight after a delay of only 1 day.
I was hoping to be able to copy the formatting and do a paste special, formats to copy the formula and color coding into each cell so that I don't have to manually enter a conditional format into each cell.

[martindwilson]

the formula i gave you works for the limited info you gave post a sample workbook
Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[PMAl]

I have uploaded a file with my problem in it.

Thanks for looking at it.