LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default VBA code help for item tracking.

Hello,
I'm asking for vba code (or resources on the web) that will help with
the following:

When a date is entered in cell a1, I would like excel to calculate if
that date was 120 days ago from TODAY(). If it wasn't, leave the cell
format alone. If it was, change the background color (to notify me the
item is overdue) until a date is entered in b1. When a date is entered
in b1, remove background color from a1 (to notify me that the item has
been checked-in).

Thanks for any help,
Russ

 
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
enter item code in one column, automatically get description in ne Shelley Kingston Excel Worksheet Functions 2 July 19th 06 12:32 PM
How to insert tracking numbers into my webpage for RMA tracking wiglady Excel Discussion (Misc queries) 0 April 4th 06 12:44 PM
How to I put a comma in between each column item from this code Adam Excel Programming 1 March 8th 05 08:40 AM
Selecting Menu Item by VBA Code PosseJohn Excel Programming 2 December 5th 04 12:24 PM
Select an item in a listbox using code Fred Jacobowitz Excel Programming 2 August 23rd 04 03:27 AM


All times are GMT +1. The time now is 08:21 AM.

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

About Us

"It's about Microsoft Excel"