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

richard_uy

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

Use empty quotes. Like: 

 

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

richard_uy

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

Mike Wilday

Try, 

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

 

richard_uy

It work perfectly. big thanks.