Issue with Copy+Pasting cells with conditional formatting

Hi all,

In a previous post I asked about how to highlight a part of a table where a last input was..input

In this case, the manual input will be the Date Paid and everything in the column (including the date paid cell) should be highlighted.
The issue is that the solution I was given uses the following equation:

=D$10=LOOKUP(10^9,$D$13:$AP$13,$D$10:$AP$10)

So when I want to copy paste the table to create an identical table below, the formatting is dependent on the original table (due to the $).

Please help me fix this issue. See attached.

Thanks!!!!

E

This didn't seem to solve my issue. Could you please attach the spreadsheet you tested it on?

Thanks!

here it is

small adjustment
insert 2 ros above tables and changed accordingly reference

Excel can do everything but still doesn't read user's mind