Formula not working

Answered - Pending Review

Hi ,

Can anyone help me with this formula issue:-

I have 4 symbol color-

Not Started- Gray

Not Applicable- No color

On Hold -Yellow

Complete- Green

Act1 greater than Act2 and Status is equal to In Progress - Red else Green

=IF( [email protected] <> "Not Applicable", IF( [email protected] = "Not Started", "Gray", IF([email protected] = "On Hold", "Yellow", "")), IF([email protected] > [email protected] , "Red", "Green"))


Sign In or Register to comment.