View Single Post
  #5   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.

Thanks for all of the responses! I'm wondering if anyone is seeing the
same thing I am: When I apply that formula to a blank cell, the cell
changes to the formatting I selected without me entering a date. Is
there a default date value in each cell that is evaluated in the
formula that would cause this change? The formula works beautifully if
there is a date already in the cell.

Many thanks again,
Russ