Thread: New macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kujo21 Kujo21 is offline
external usenet poster
 
Posts: 1
Default New macro


I'm trying to create a new macro so that I can calculate dates and the
results show up as a cell being a solid color. Heres the info I'm
working with. I have a future date, I need to compare it to todays
date. When there are 14+ days its green, 2-13 days yellow, 0-1 red, a
- number is black. Any help would be greatly appreciated. I'm just
learning all this.


--
Kujo21
------------------------------------------------------------------------
Kujo21's Profile: http://www.excelforum.com/member.php...o&userid=32484
View this thread: http://www.excelforum.com/showthread...hreadid=522693