Conditional Formatting - Difference between dates
 

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


--
Gohan51D
------------------------------------------------------------------------
Gohan51D's Profile: http://www.excelforum.com/member.php...o&userid=32274
View this thread: http://www.excelforum.com/showthread...hreadid=521938

Conditional Formatting - Difference between dates
 

Hi!

If I understand....

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

Biff

"Gohan51D" wrote in
message ...

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


--
Gohan51D
------------------------------------------------------------------------
Gohan51D's Profile:
http://www.excelforum.com/member.php...o&userid=32274
View this thread: http://www.excelforum.com/showthread...hreadid=521938

Conditional Formatting - Difference between dates
 

Biff wrote:
Hi!

If I understand....

Select cell B1
Goto FormatConditional 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-A19))

Conditional Formatting - Difference between dates
 

If I understand....
That highlights cells that are IN the window.

That must mean that I didn't understand!

Biff

"Paul Lautman" wrote in message
...
Biff wrote:
Hi!

If I understand....

Select cell B1
Goto FormatConditional 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-A19))

Conditional Formatting - Difference between dates
 

True, I didn't think of it that way!

Biff wrote:
If I understand....
That highlights cells that are IN the window.

That must mean that I didn't understand!

Biff

"Paul Lautman" wrote in message
...
Biff wrote:
Hi!

If I understand....

Select cell B1
Goto FormatConditional 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-A19))

Conditional Formatting - Difference between dates
 

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

Biff wrote:
Hi!

If I understand....

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

Biff

"Gohan51D"
wrote in message
...

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


--
Gohan51D
------------------------------------------------------------------------
Gohan51D's Profile:
http://www.excelforum.com/member.php...o&userid=32274
View this thread:
http://www.excelforum.com/showthread...hreadid=521938