Date Function and Color Code

J

JEN1752

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!
 
D

David Biddulph

Format/ Conditional Formatting/ Formula is:
=AND($A10>TODAY(),$A10<DATE(YEAR(TODAY()),MONTH(TODAY())+3,DAY(TODAY())))
Choose format accordingly
 
Top