Conditional Formatting

[tjeffords]

Hello everyone,

I’m currently trying to figure out how to make a row consisting of 5 cells change color based on the output of the 5th cell. The conditional formatting of the 5th cell already puts an icon in that cell depending on the value in it but I’m also trying to format all 5 cells to change to a color that coincides with that 5th cells conditional formatting.

The 5th cell is formatted to have the following:
• Green checkmark when the value is ≥ 52%
• Yellow Exclamation Point when value is ≥ 50% but < 52%
• Red X when the value is > 50%
I’m trying to get the lines to fallow suite with the fill colors. I have uploaded the file unlocked so you can see what I’m talking about

Any and all help will be greatly appreciated thank you in advance,

TJ

Also if you have an idea to easily hid the "#DIV/0!" That would be awesome. Thanks again

[José Augusto]

Hi
Your Conditional Formatting are almost right. You should just have one rule applied to the whole set of cells.
As to #DIV0! you can avoid using the formula with =IFERROR (your expression,"")

[Richard Buttrey]

See attached.

The 'Formula Is' conditional formats are:
Red: =$F2<0.5
Green =$F2>0.52
Orange =AND($F2>=0.5,$F2<0.52)

[tjeffords]

you all are freaking awesome!!!! Ive been trying to figure that out for like 3 weeks now!!! and you all helped me out in less then 20 min! I love you guys