View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] russell.estes@gmail.com is offline
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