RGYB color change based on Status
I have gone through a lot of posts in this community and tried a bunch of formulas and can't get it to work.
I have 5 statuses in the Status column dropdown
- Not Started
- In Progress
I would like the RGYB colour to change based on the status.
- Not Started, and Complete - Blue
- In Progress - Green
- Delayed - Yellow
- Behind - Red
The most recent formula I tried, which I found in the discussion forum and it was working for the individual that posted is:
=IF(Status@row = "In Progress", "Green", IF(Status@row = “Delayed”, "Yellow", IF(Status@row = "Behind", "Red", IF(Status@row = "Complete", "Blue”, “Blue”))))
I continually get an unparsable error. Would greatly appreciate any and all assistance.
Help Article Resources
Check out the Formula Handbook template!