LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
mike099
 
Posts: n/a
Default Having a due date flag in a different colour 30 days from current.

I have a maintenance schedule for a fleet of 100 trucks. Not all come due at
the same time. I have a spreadsheet set up now that calculates when the PM's
and Annual Inspections are due but I would like something that stands out
when I look at the list to say yes, this unit is due this month, without
having to go through the whole list and manually pick out the ones due for
Jan. Then next month, have all due in Feb. be highlighted or maybe 5 days
before the new month begins.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Lock in current date Angus Excel Discussion (Misc queries) 1 January 12th 05 05:27 PM
subtracting 30 days from any date. help me Excel Discussion (Misc queries) 1 December 17th 04 04:27 AM
How would I change a date cell to decrease it by business days? CNGracin Excel Discussion (Misc queries) 3 December 15th 04 05:20 PM
How to change (delivery) days and automatically the receive date in an other cell? Elboo Excel Worksheet Functions 5 November 22nd 04 02:44 PM
How do I program a cell to automaticinput the current date as dat. ces Excel Worksheet Functions 1 November 8th 04 11:11 PM


All times are GMT +1. The time now is 10:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"