Changing Color of a Cell

[foozay]

Hi

I need help!! I am trying to change the color of a cell depending on the cells next to it.

Example.

Change cell A2 to red if any of the cells from B2:S2 are red

Additional info:

cells B2:S2 change color depending on what they contain - either red,yellow, or orange - I used conditional formatting for that

cells B2:S2 contain dates - depending on how close the date is to todays date, the color will change ( like a warning system)

Thank you for your help

 

[SamTYler]

Foozay,

You're welcome.

That's the great thing about this board, you will often get many solutions from which you can choose the one that fits you best.