Conditional Formatting formula problem

V

Voodoodan

Hi,

I want to conditionally format a cell (C1), but here's the problem.

I send off a form to someone and leave "Awaiting" in cell B1. I pu
the date I sent off the form in cell A1. If the date exceeds 21 day
from A1 then "Awaiting" in B1 is highlighted in bold red. However, i
a form comes back I will type a date into B1, overwriting "Awaiting"
to which I want the font to normalise.

I hope that makes sense!!

If you know the conditions for this I would be most grateful!

Thanks,
Dan
 
E

Earl Kiosterud

Dan,

I think you mean "If the current date exceeds 21 days." If so, try this.

Formula is:
=AND($A$2="Awaiting",A1<NOW()-21)
 
E

Earl Kiosterud

Dan,

Oops,

I used A2 when I shouldda used B1.
=AND($B$1="Awaiting",A1<NOW()-21)

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

Earl Kiosterud said:
Dan,

I think you mean "If the current date exceeds 21 days." If so, try this.

Formula is:
=AND($A$2="Awaiting",A1<NOW()-21)
Click to expand...
 
V

Voodoodan

I used Earl's version in the end, but thanks for all the response
received for this.

It works perfectly.

Thanks very much.
Dan
 
Top