Conditional Formatting

[Igor1207]

I need some help in making a spreadsheet work as follows:

I have six columns which when filled with a Y change colour and that all looks nice and dandy!

However, I now need the column next to them to change based upon the number of Ys in the other columns.

For instance: 2Ys = LOW in text with a red background, 4Ys = MEDIUM in text with an amber background, 6Ys = HIGH in text with a green background.

Could you please let me know if this is achievable.

Thanks in advance.

 

[bbott]

welcome to the board.

Assuming your y values are in A5:F5, try something like this in G5:

=IFERROR(CHOOSE(INT(COUNTIF(A5:F5,"Y")/2),"Low","Medium","High"),"")

Then set the appropriate conditional formatting.

**Keep in mind that this will return nothing for no y's or 1 y.

 

[bbott]

Your conditional format formulas would be:

=G5="Low"
format as red

=G5="Medium"
format as yellow

=G5="High"
format as green