software

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: www.excelforum.com/member.php...oamp;userid=32274
View this thread: www.excelforum.com/showthread...hreadid=521938Hi!

If I understand....

Select cell B1
Goto Formatgt;Conditional Formatting
Formula is: =AND(B1lt;gt;quot;quot;,B1gt;=A1 4,B1lt;=A1 8)
Click the Format button
Select the desired style(s)
OK out

Biff

quot;Gohan51Dquot; gt; wrote in
message ...
gt;
gt; If A1 is a date and B1 is a date. B1 is always scheduled to be 7 days
gt; after A1 but can be /- 2 days. I need to hilight B1 when it is out of
gt; the /- 2 day window with out hilighting empty cells.
gt;
gt; Thanks
gt; Gohan51D
gt;
gt;
gt; --
gt; Gohan51D
gt; ------------------------------------------------------------------------
gt; Gohan51D's Profile:
gt; www.excelforum.com/member.php...oamp;userid=32274
gt; View this thread: www.excelforum.com/showthread...hreadid=521938
gt;
Biff wrote:
gt; Hi!
gt;
gt; If I understand....
gt;
gt; Select cell B1
gt; Goto Formatgt;Conditional Formatting
gt; Formula is: =AND(B1lt;gt;quot;quot;,B1gt;=A1 4,B1lt;=A1 8)
gt; Click the Format button
gt; Select the desired style(s)
gt; OK out
gt;
gt; Biff
That highlights cells that are IN the window.

try =AND(NOT(ISBLANK(B1)),OR(B1-A1lt;5,B1-A1gt;9))
gt; If I understand....
gt; That highlights cells that are IN the window.

That must mean that I didn't understand!

Biff

quot;Paul Lautmanquot; gt; wrote in message
...
gt; Biff wrote:
gt;gt; Hi!
gt;gt;
gt;gt; If I understand....
gt;gt;
gt;gt; Select cell B1
gt;gt; Goto Formatgt;Conditional Formatting
gt;gt; Formula is: =AND(B1lt;gt;quot;quot;,B1gt;=A1 4,B1lt;=A1 8)
gt;gt; Click the Format button
gt;gt; Select the desired style(s)
gt;gt; OK out
gt;gt;
gt;gt; Biff
gt; That highlights cells that are IN the window.
gt;
gt; try =AND(NOT(ISBLANK(B1)),OR(B1-A1lt;5,B1-A1gt;9))
gt;
True, I didn't think of it that way!

Biff wrote:
gt;gt; If I understand....
gt;gt; That highlights cells that are IN the window.
gt;
gt; That must mean that I didn't understand!
gt;
gt; Biff
gt;
gt; quot;Paul Lautmanquot; gt; wrote in message
gt; ...
gt;gt; Biff wrote:
gt;gt;gt; Hi!
gt;gt;gt;
gt;gt;gt; If I understand....
gt;gt;gt;
gt;gt;gt; Select cell B1
gt;gt;gt; Goto Formatgt;Conditional Formatting
gt;gt;gt; Formula is: =AND(B1lt;gt;quot;quot;,B1gt;=A1 4,B1lt;=A1 8)
gt;gt;gt; Click the Format button
gt;gt;gt; Select the desired style(s)
gt;gt;gt; OK out
gt;gt;gt;
gt;gt;gt; Biff
gt;gt; That highlights cells that are IN the window.
gt;gt;
gt;gt; try =AND(NOT(ISBLANK(B1)),OR(B1-A1lt;5,B1-A1gt;9))

Actually changing your formula to: =NOT(AND(B1=quot;quot;,B1gt;=A1 4,B1lt;=A1 8))
should work

Biff wrote:
gt; Hi!
gt;
gt; If I understand....
gt;
gt; Select cell B1
gt; Goto Formatgt;Conditional Formatting
gt; Formula is: =AND(B1lt;gt;quot;quot;,B1gt;=A1 4,B1lt;=A1 8)
gt; Click the Format button
gt; Select the desired style(s)
gt; OK out
gt;
gt; Biff
gt;
gt; quot;Gohan51Dquot; gt;
gt; wrote in message
gt; ...
gt;gt;
gt;gt; If A1 is a date and B1 is a date. B1 is always scheduled to be 7
gt;gt; days after A1 but can be /- 2 days. I need to hilight B1 when it
gt;gt; is out of the /- 2 day window with out hilighting empty cells.
gt;gt;
gt;gt; Thanks
gt;gt; Gohan51D
gt;gt;
gt;gt;
gt;gt; --
gt;gt; Gohan51D
gt;gt; ------------------------------------------------------------------------
gt;gt; Gohan51D's Profile:
gt;gt; www.excelforum.com/member.php...oamp;userid=32274
gt;gt; View this thread:
gt;gt; www.excelforum.com/showthread...hreadid=521938