I'm usually quite good with conditional formatting but I don't think it can
handle what I need.
Let's say in cell A1 I have a date.
In cell A3 I have the conditional format =(TODAY()-A128) shade in red.
(If it's more than 28 days from the date show me in red)
If I enter a date in cell A2 then I want the conditional format to be ignored.
Can this be done with conditional formatting or will it take
VB?
If it's
VB what would you suggest?
Thanks.