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

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

"Gohan51D" <Gohan51D.24mnwo_1142286001.8849@excelforum-nospam.com> wrote in
message news:Gohan51D.24mnwo_1142286001.8849@excelforum-nospam.com...
>
> 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
>

Biff wrote:
> 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))

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

That must mean that I didn't understand!

Biff

"Paul Lautman" <paul.lautman@btinternet.com> wrote in message
news:%23AQRrruRGHA.1160@TK2MSFTNGP09.phx.gbl...
> Biff wrote:
>> 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))
>

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" <paul.lautman@btinternet.com> wrote in message
> news:%23AQRrruRGHA.1160@TK2MSFTNGP09.phx.gbl...
>> Biff wrote:
>>> 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))

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 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
>
> "Gohan51D" <Gohan51D.24mnwo_1142286001.8849@excelforum-nospam.com>
> wrote in message
> news:Gohan51D.24mnwo_1142286001.8849@excelforum-nospam.com...
>>
>> 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