Re: Track Annual Inspection Due Dates Using Conditional Formatting
- From: "Bob Phillips" <bob.phillips@xxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 7 Dec 2005 14:00:32 -0000
Select the date cells, let's assume starting at A1
Menu Format>Conditional 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" <Scatman@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:6E2863C5-03F5-4C4D-813A-2CEDC9EA0EF0@xxxxxxxxxxxxxxxx
> I am trying to make a work*** 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.
.
- Prev by Date: Re: Count
- Next by Date: Syntax for using "IF"...
- Previous by thread: Re: Instead of a negative number, I'd like to show zero...
- Next by thread: Re: Track Annual Inspection Due Dates Using Conditional Formatting
- Index(es):
