Status related to % Complete

E Redd

I am trying to accomplish the following formula:

100% status turns green

1%-99% status turns yellow

0%= Gray

work paused = red

Is this possible with red?

Devin Lee

It would look something like this

=IF([email protected]="work paused","Red",IF([email protected]=0,"Gray",IF([email protected]=1,"Green","Yellow")))

Devin Lee

It would look something like this

=IF([email protected]="work paused","Red",IF([email protected]=0,"Gray",IF([email protected]=1,"Green","Yellow")))

E Redd

Thank you Devin!

It didn't entirely work for me. States "Circular reference", but I did modify to use.