I'm using excel 2003 and wanted to know if it is possible to do conditional formatting based on the reference values of other cells. In the attached document, can I make columns Z, AA and AC shaded to the same color as AB?
My goal is to select this entire week of cells and just drag it down for a year.
Bookmarks