Copying Conditional Formatting

[DonC]

I update a production tracker weekly, and want to compare each weeks
production to the corresponding week from last year. I have the
tables set up side by side on a single tab. Since I will have over
300+ cells to compare, I don not want to input the condititional
format for comparing this year to last year in each cell. Is there a
way to copy the condititional formating so that the right cell is
compared to its counterpart between the two tables.

 

[Bob Umlas]

it'd help if you supplied the current CF formula you're using