Hi,

Highlight B2:B171 or whatever,

If you always enter a date in F4 then choose Format, Conditional Formatting,
Formula is and enter the formula

=B2=F$4+180


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Derek" wrote:

Ok so I have a sheet containing dates in cells B2 through B171. I want the
cells to highlight based on a date that is in cell F4. I want it to
hightlight all the dates from the date in F4 + 180 days. That way when I
change the date in F4 it will change the highlighted dates in B2:B171.
Please Help !!! Thanks