Formatting based on reference cell value

Closed
David - Jun 24, 2016 at 02:21 PM
Hello,
I have a worksheet that has numbered columns as DAYS relative to day zero, a column (Y) that has an offset value, and rows with counts of items for each relative day by Person (row).
For each Person (row) with an offset value(X), I would like to change back color of the cell that is X columns (same row) to the right of Day Zero. Are there VBA or conditional formatting solutions?

Thanks,