Questions

Answer for:

Conditional Formatting

Message 3 of 5

View entire thread
+
0 Votes
ThumbsUp2

Yes, you can do that. All you need is a compound IF statement. You didn't say what it was that you're using to apply your conditional formatting, but here's the logic:

IF past the deadline
- APPLY red to appropriate cell
ELSE
- IF delivered
-- APPLY green to appropriate cell and show delivered
- ELSE do nothing
END

---