if with blank cell, RYG ball how to become Yellow.

richard_uy · 03/23/18

Hi,

As per below formula, if with blank cell, How can i add the formula for RYG ball auto change to Yellow.

=IF(ETA11 > TODAY(), "Green", IF(ETA11 < TODAY(), "Red"))

Thanks in advance.

MattH · 03/23/18

Use empty quotes. Like:

=IF(ETA11 > TODAY(), "Green", IF(ETA11 < TODAY(), "Red", IF(ETA11 = "", "Yellow", ""))

richard_uy · 03/23/18

Hi Matth, can't work, RYG ball still with Red.

Mike Wilday · 03/23/18

Try,

=IF(ISblank(ETA11),"Yellow", IF(ETA11 > TODAY(), "Green", IF(ETA11 < TODAY(), "Red", "")))

richard_uy · 03/26/18

It work perfectly. big thanks.

Comments