View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
HR gal
 
Posts: n/a
Default How to Highlight the date if it is within 3 months from now

I am working with a spreadsheet having to do with various training my staff
must have. Some of the certificates expire after a few years, and I wanted
to enter a function so that a cell is highlighted when it is within 3 months
from expiring, so that I will know to schedule a new training session. I
tried using the Conditional Formatting option, but wasn't sure what formula
to write. Help!