# Conditional Formating for Date

#### crosejr

##### New Member
I am trying to create a conditional format for a cell to be red if the date in the cell is more than 1095 (3 years), green if it is less than 1095 or no color if no data is in the cell. Then how do I copy this formula to a group of cells.

### Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
Hi and welcome to the board!!!
In CF, use the Formula Is option.
Condition 1
=A1*(A1>Today()+1095) Format Red
Condition 2
=A1 Format Green

lenze

I am sorry for my lack of knowledge but what is the reference to A1

I am sorry for my lack of knowledge but what is the reference to A1
Sorry for not being specific. A1 is generally used for example purposes. In this case, A1 would be the cell that CF is being applied to. Just make an adjustment for other cells. So, for C10, you would use
Code:
``````'Condition 1
=C10*(C10>Today()+1095) 'Format Red
'Condition 2
=C10 Format 'Green``````

lenze

I finally got the following to work:

=A1*(A1+1095<Today()) 'Red
=A1*(A1+1050<Today()) 'Yellow
=A1 ' Green

I am assuming you can only put three conditions per cell?

Thanks for pointing me in the right direction!

Some how the following post missed up

I finally got the following to work:

"=A1*(A1+1095<TODAY())" ' RED

"=A1*(A1+1050<TODAY())" ' YELLOW

"=A1" ' Green

I am assuming you can only put three conditions per cell?

Thanks for pointing me in the right direction!

<!-- / message -->

I am having problems posting the formula to show everything. Is there a setting you have to use to post a formula?

When you have a "< " or ">" in your formula, sometimes the board reads it as html code. So, be sure and place a space before and after it. Also, use CODE TAGS
lenze

Replies
4
Views
226
Replies
3
Views
1K
Replies
5
Views
511
Replies
7
Views
513
Replies
3
Views
1K

1,203,244
Messages
6,054,365
Members
444,718
Latest member
r0nster

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back