Color Auto-Changes

megtimmi

I have my sheet coded so that the status updates as the due date approaches, passes, etc. The only problem is that in a row where the due date is blank it considers it 'Late' and makes it red.  I would like for it to just leave the status blank in that row.  This is the formula I had used:

=IF([Date Due]3 < TODAY(), "Red", IF([Date Due]3 = TODAY(), "Yellow", IF(TODAY() - [Date Due]3 > -3, "Yellow", IF([Date Due]3 > TODAY(), "Green"))))

Does anybody know what I should add to the line to make what I want happen?

Mike Wilday

Try modifying your formula to...

=IF(ISBLANK([Date Due]3), "", IF([Date Due]3 < TODAY(), "Red", IF([Date Due]3 = TODAY(), "Yellow", IF(TODAY() - [Date Due]3 > -3, "Yellow", IF([Date Due]3 > TODAY(), "Green")))))

Did that work for you? 

megtimmi

Yes that worked! Thank you!

Mike Wilday

You're welcome!