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