Posted to microsoft.public.excel.worksheet.functions

Scatman

Posts: n/a

Track Annual Inspection Due Dates Using Conditional Formatting

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I create conditional formatting to track due dates	Soraiya	Excel Worksheet Functions	2	October 14th 05 03:26 PM
Conditional Formatting Cell < Today()	sagan	Excel Worksheet Functions	3	September 21st 05 03:43 PM
Conditional Formatting Dates	John	Excel Worksheet Functions	11	December 29th 04 08:43 PM
How do I get more than 3 Conditional formatting?	TSgt Ed	Excel Discussion (Misc queries)	1	December 29th 04 07:04 PM
Conditional Formatting for dates	spacerocket	Excel Worksheet Functions	2	November 4th 04 10:13 AM

All times are GMT +1. The time now is 09:33 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us