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))