ExcelBanter - Date Function and Color Code

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Date Function and Color Code (https://www.excelbanter.com/excel-worksheet-functions/125244-date-function-color-code.html)

JEN1752

Date Function and Color Code

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!

Teethless mama

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!

David Biddulph

Date Function and Color Code

Format/ Conditional Formatting/ Formula is:
=AND($A10TODAY(),$A10<DATE(YEAR(TODAY()),MONTH(TO DAY())+3,DAY(TODAY())))
Choose format accordingly
--
David Biddulph

"JEN1752" wrote in message
oups.com...
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!

All times are GMT +1. The time now is 11:39 AM.