I have a sales goal tracking spreadsheet that represents one period (month)
at a time. I have Sun - Sat across the top, then the categories (retail,
Corp, mail order, etc on the side.
For each day of the week, I have the Last Year's ACTUAL sales, the GOAL
number (usually 150% of LY), then THIS YEAR'S ACTUAL sales number. Obviously,
this is repeated three more times (going down the spreadsheet for each week).
I have used the conditional formatting to tell the TY Actual number to be
red or green based on if we exceed LY actual or not for each category. No
problem there. The problem is when I tried to use Format Painter so that I
didn't have to do every TY Actual cell, it keeps the reference cell instead
of understanding it needs the corresponding LY Actual cell that is two
columns over from it.

Is there a quick way to format the TY Actual cells?

Thanks in advance for you help!

Maggie