I would like a conditional formatting in
column A would be RED if the range from B to D has a color RED.
column A would be YELLOW if the range from B to D is YELLOW OR GREEN
column A would be GREEN if the range from B to D is all green


A B C D
RED YEllow Green Red
YELLOw Green YELLOW GREEN
GREEN GREEN GREEN GREEN

Thanks!

A1
=IF(COUNTIF($B1:$D1,"Red")0,"Red",IF(COUNTIF($B1: $D1,"Green")=3,"Green","Yellow"))
Copy down from A1 to A3

Condition Formatting
condition 1: =A1="Red" (format as red)
condition 2: =A1="Yellow" (fromat as yellow)
condition 3: =A1="Green" (format as green)


"Conditional Formatting" wrote:

I would like a conditional formatting in
column A would be RED if the range from B to D has a color RED.
column A would be YELLOW if the range from B to D is YELLOW OR GREEN
column A would be GREEN if the range from B to D is all green


A B C D
RED YEllow Green Red
YELLOw Green YELLOW GREEN
GREEN GREEN GREEN GREEN

Thanks!