vb needed i think...

[Guest]

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()-A1>28) 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.

 

[Guest]

=(TODAY()-A1>28)*(A2="")

clearly once you put something in A2 the condition will fail.

 

[Guest]

Perhaps you can use conditional formats with two conditions linked with Or
something like this ...

=Or(A2>0, (TODAY()-A1>28))

 

[Guest]

Thanks Gary''s Student, worked perfectly.

=(TODAY()-A1>28)*(A2="")

clearly once you put something in A2 the condition will fail.