Conditional Formatting - Difference between dates

G

Gohan51D

If A1 is a date and B1 is a date. B1 is always scheduled to be 7 days
after A1 but can be +/- 2 days. I need to hilight B1 when it is out of
the +/- 2 day window with out hilighting empty cells.

Thanks
Gohan51D
 
B

Biff

Hi!

If I understand....

Select cell B1
Goto Format>Conditional Formatting
Formula is: =AND(B1<>"",B1>=A1+4,B1<=A1+8)
Click the Format button
Select the desired style(s)
OK out

Biff
 
P

Paul Lautman

Biff said:
Hi!

If I understand....

Select cell B1
Goto Format>Conditional Formatting
Formula is: =AND(B1<>"",B1>=A1+4,B1<=A1+8)
Click the Format button
Select the desired style(s)
OK out

Biff
That highlights cells that are IN the window.

try =AND(NOT(ISBLANK(B1)),OR(B1-A1<5,B1-A1>9))
 
P

Paul Lautman

Actually changing your formula to: =NOT(AND(B1="",B1>=A1+4,B1<=A1+8))
should work
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top