Hello,

I have Windows XP, and I need help with a macro to do the following without changing the content of any cell....

IF any cell C3 through P3 is RED, THEN make cells A3 and B3 RED.
Else, IF any cell C3 through P3 is ORANGE, THEN make cells A3 and B3 ORANGE.
Else, IF any cell C3 through P3 is YELLOW, THEN make cells A3 and B3 YELLOW.
Else, leave cell WHITE.

This would be applied to all the other cells in the same column...

Thank you for your help.