Arguments

[Ra]

Please can you help me with the following:

I have 4 cells: M5, R5, W5, AB5

These contain conditional formatting which can either turn green or red
depending on the argument specified in the conditional formatting.

If all the above cells are green, I would like AF5 to turn green.
On the other hand, if any of the above cells turn red, I would like AF5 to
turn red.

Any help would be greatly appreciated.

 

[Jim Thomlinson]

You need to create a single formula that combines the the logic of the other
four cells.

=and(m5>0, R5>0, w5>0, ab5>0)
or something like that...

 

[Gary''s Student]

Set the default color to red and then use a single conditional format:
=IF(AND(condition for M5,condition for R5,condition for W5,condition for AB5))

and set that green.