Green, Yellow, Red Blue Formatting
Newbie here. Trying to set some formatting for some specific RYGB and I can only get it to work for Yellow. Any thoughts? I receive the #INCORRECT ARGUMENT error. Thanks in advance!
=IF([Completed%]2 = 1, "Green", IF(AND(Today1 > Start2, Today1 < Finish2, [Completed%]2 = 0), "Yellow", IF(Start2 > $Today$1, [Completed%]2 = 0, "Blue", IF($Today$1 > Finish2, "Red"))))
Help Article Resources
Check out the Formula Handbook template!