conditional format; if last cell in column is less than the second last

[ajm]

folks, i use a formula row to update a table each week. that is, i have all the formulas in a row above the table, and then each week when the new data comes out, i copy the formula row below the table, pasting these as values. this is to keep each week of data as a static point in time row. i made a silly mistake today where i forgot to update a separate range which impacted my calculations. to avoid this happening again, i want to add a conditional format to the formula row that will work when i copy the row below the table. this is to highlight when the new number is less than last week's number. it should always be higher. i have tried a simple if statement but the applies to keeps changing to absolute

 

[steve the fish]

This looks a little odd but should work for you. You need a CF formula:

=AND(D1048576<>"",D1<>"",D1<=D1048576)

applied to D:D

 

[ajm]

This looks a little odd but should work for you. You need a CF formula:

=AND(D1048576<>"",D1<>"",D1<=D1048576)

applied to D:D

Thanks Steve.

works like a charm. How though? it defies logic (well, my slim grasp of logic anyway).