Date Function and Color Code

  • Thread starter Thread starter JEN1752
  • Start date Start date
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!
 
Format/ Conditional Formatting/ Formula is:
=AND($A10>TODAY(),$A10<DATE(YEAR(TODAY()),MONTH(TODAY())+3,DAY(TODAY())))
Choose format accordingly
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting dates 3
Excel VBA 1
Formula with dates in COLOR 3
Excel VBA - counting cells by colors and names to it in two different rows. 0
Recognize Color and Insert Symbol 6
Conditional Formatting for multiple cells 2
Color Code Date Checking 3
Excel VBA to move cells to sheet2 based on selection in sheet1 0

Back
Top