Thread: A function to make date red if it is over 30 days old
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
intruder9
 
Posts: n/a
Default A function to make date red if it is over 30 days old

You could use conditional formating. Say you chose a cell A1, in this
cell you enter the date you are looking to compare to the date in
question. Select the date you want to turn red, for this example we
will use F3 and click FORMAT CONDITIONAL FORMAT chose "Formula is"
in the drop down box and for the formula put =(F3-A1)30, now press on
the format box and choose red for the font color. Whenever this is
above 30 days apart the date will turn red.


--
intruder9
------------------------------------------------------------------------
intruder9's Profile: http://www.excelforum.com/member.php...o&userid=30107
View this thread: http://www.excelforum.com/showthread...hreadid=497972

Reply With QuoteReply With Quote