Automate RYG (percentages)

Gonzalo Suarez V.

Hi everyone, probably more of the same, but I cannot make my formula work... what I want is to change the color according to percentages in a different column, 0%to 33% Red, 34%to66%Yellow and 67% to 100% turn to green. 

I have used this formula, but is not working, any other thoughts around this?

=IF([% Complete]1<=33,"Red",IF(AND([% Complete]1>33,[% Complete]1<=66)=TRUE,"Yellow","Green"))

Thanks

Mike Wilday

When numbers are formatted as percentages, then you need to reference them as portions of 1. Try this: =IF([% Complete]1<=.33,"Red",IF(AND([% Complete]1>.33,[% Complete]1<=.66)=TRUE,"Yellow","Green"))

See if that works. 1=100%. 

Gonzalo Suarez V.

Hi Mike, thanks for your answer, but still, this is not working... I've used your formula,  but I'm getting the same results: #UNPARSEABLE...

 

Mike Wilday

Doh..  I didn't notice some extra text you had in there. I removed the =True part. Try this... 

=IF([% Complete]1<=.33,"Red",IF(AND([% Complete]1>.33,[% Complete]1<=.66),"Yellow","Green"))

Gonzalo Suarez V.

Yeah!!! That's it, now is working, thanks for your help Mike... brilliant!

Mike Wilday

Glad I could assist!