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