Green, Yellow, Red Blue Formatting

Erin Miller

Hello,

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"))))

Ameya Athalye

Try this?

=IF([Completed%]2 = 1, "Green",

IF(AND([Today]1 > [Start]2, [Today]1 < [Finish]2, [Completed%]2 = 0), "Yellow",

IF(AND([Start]2 > [Today]1, [Completed%]2 = 0), "Blue", "Red")))

Ameya Athalye

Try this?

=IF([Completed%]2 = 1, "Green",

IF(AND([Today]1 > [Start]2, [Today]1 < [Finish]2, [Completed%]2 = 0), "Yellow",

IF(AND([Start]2 > [Today]1, [Completed%]2 = 0), "Blue", "Red")))

Erin Miller

Perfect! Thank you for the help!