Hi everyone,

I'm trying to apply conditional formatting which checks the current date and then looks at the date some work should be completed, highlighting the cell with the due date (D5) in yellow as a reminder.

I've used the formula - =AND($K5="",$D5>"", (TODAY()-$D5)>-3)

And it works just fine on row 5.

But I want to copy the conditional formatting to the next 200 rows so that each formula refers to the data in the relevant row - 6, 7, etc. up to 204.

Whether I copy and paste or use format painter down the column, the formula keeps referring to row 5.

How do I get the formula to increment the row number in the formula to test each relevant row's data?

Thanks