Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
209
Views
Topic starter
I want dates older than two week from today to have cell filled with color. My formula works but how to I prevent blank cells from being filled as well?
=$AA2<TODAY()-14
Posted : 05/08/2022 3:19 pm
Hi Chuck,
Welcome to our forum!
Try this formula:
=AND($AA2<>"",$AA2<TODAY()-14)
Mynda
Posted : 05/08/2022 8:14 pm