Red, Yellow, Green multiple columns

Crysn

Hello,

I'm trying to create a formula that will put out a color according to multiple colors in a column. For example: there are columns 1 thru 6 that are rated red, yellow or green. In column 7, if any are yellow, it will output a yellow and if any are red, will output a red dot; if all are green, will output a green dot. I know how to do it for yellow and green, not sure how to add red to the equation. This is what I have so far:

=IF(OR([Column1]@row = "Yellow", [Column2]@row = "Yellow", [Column3]@row = "Yellow", [Column4]@row = "Yellow", [Column5]@row = "Yellow", [Column6]@row = "Yellow"), "Yellow", "Green")

heyjay

=IF(COUNTIF(A@row:C@row, "Red") > 0, "Red", 
IF(COUNTIF(A@row:C@row, "Yellow") > 0, "Yellow", 
"Green"))

Assuming that your status columns are side by side, replace A@row:C@row with the first and last column. eg Column1@row:Column6@row

heyjay

What if there is a RED and YELLOW, what should it output? What color is the priority?

Crysn

If there are any red, it will output a red dot. These are risk ratings. Green = no risk, yellow = medium risk, red = high risk.

heyjay

=IF(COUNTIF(A@row:C@row, "Red") > 0, "Red", 
IF(COUNTIF(A@row:C@row, "Yellow") > 0, "Yellow", 
"Green"))

Assuming that your status columns are side by side, replace A@row:C@row with the first and last column. eg Column1@row:Column6@row

Crysn

That worked, thank you! I was over complicating it.