vb needed i think...

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
=(TODAY()-A1>28)*(A2="")

clearly once you put something in A2 the condition will fail.
 
Perhaps you can use conditional formats with two conditions linked with Or
something like this ...

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