Farah Mohammed
asked on
Conditional Formatting Help
I have a conditional formatting formula that highlights every that is older than today
=$I2<=TODAY()
How do I tell it to look at column I and highlight anything older than 3 months (90 days)?
Thank you
=$I2<=TODAY()
How do I tell it to look at column I and highlight anything older than 3 months (90 days)?
Thank you
ASKER
Barry
I understand your formula, but you can see from attached that it highlighted dates not older than 90 days and not all the rows that are older than 90 days (see row 96) are changed to red.
Thank you for your help.
book1.xlsx
I understand your formula, but you can see from attached that it highlighted dates not older than 90 days and not all the rows that are older than 90 days (see row 96) are changed to red.
Thank you for your help.
book1.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for pointing out my error. Your help is appreciated.
=$I2<=TODAY()-90
that could highlight blank cells too, so to stop that change to
=AND($I2<>"",$I2<=TODAY()-
regards, barry