View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default Date Function and Color Code

Conditional Formatting
=AND(A1=TODAY(),A1<=DATE(YEAR(TODAY()),MONTH(TODA Y())+3,DAY(TODAY())


"JEN1752" wrote:

Hello I am hoping someone can help me out. I am trying to perform the
following.

The first column of my worksheet is a date. I would like to have my
ROWS color coded depending on the date in the first column.

If the date is from 0-3 months from NOW then color green.

Any ideas. Thanks much!