View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FEVOOO FEVOOO is offline
external usenet poster
 
Posts: 7
Default Conditional formatting dates

Hey guy's,

I have sheet with some data for employe info. One column Is there ID's expire date
In this column I need to use the conditional formatting to make alert by green color before 2 month of the expire date and the yellow color before one month and from the expire date and up till today getting red.

Please help.