View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JPS JPS is offline
external usenet poster
 
Posts: 47
Default Date Calculation in Conditional Formatting

I have a column of dates and if a date is 6 month or less in the future of
the current month TODAY(), I need to have the cell red. I know this can be
accomplished through conditional formatting but need some guidance on the
formula.

Thanks
--
JPS