View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MWad22368
 
Posts: n/a
Default I want to use a formula in excel to highlight a cell 30 days prio

I am using Excel 2003. I want to have Excel highlight the cell 30 days prior
to the date that I put into the cell. Example 4/30/06...I want excel to
highlight the cell yellow 30 days prior to that date. Also...I want excel to
highlight the cell red when the date has past (expired).