I have a work sheet that has columns that contain dates. I want to format the rows based on weather the cell has a date or not. I tried to attach a screen shot but i am unsure if it it taking or not.
but if cell 2 c has a date i want cells 2a, 2b and 2c to be a certain color. If 2d has a date I want 2a, 2b and 2c to e one color. I have figured it out this far fairly well although in the long run it takes about 10 formulas (one for each column) to achieve this. I have not figured out how to then carry this through the work book without having to go through the same process every time. I have tried to remove the $ to keep it from being absolute but then when i close or save it defaults to that. Any ideas? I know my question might be clear a mud.

Untitled.jpg