Select the date cells, let's assume starting at A1
Menu FormatConditional Formatting
Change Condition 1 to Formula Is
Add a formula of =AND(A1+5=TODAY(),A1<=TODAY())
Click the Format button
Select the Pattern Tab
Select an appropriate highlighting colour
OK
OK


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Scatman" wrote in message
...
I am trying to make a worksheet that will track the annual inspection
dates
for my equipment and basically change color when the inspections are
comming
due or are overdue. Im using conditional foramtting what would the formula
be
if i did an inspection on 6-sep-05 and i want excel to tell me when it is
5
days before the due date which would be 6-sep-06.