View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Scottmk[_12_] Scottmk[_12_] is offline
external usenet poster
 
Posts: 1
Default Conditional Format ?

Hi
I have a cell that =today(). Then, I have a column of due dates fo
rows. I would like to set up a conditional format that turns the du
date cells green, yellow, or red if they are 3,2,or 1 week(s) out. An
ideas?
Thank

--
Message posted from http://www.ExcelForum.com