Conditional Formating for Date

[crosejr]

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.

Thanks for any advise!

 

[lenze]

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

 

[crosejr]

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

 

[lenze]

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

'Condition 1
=C10*(C10>Today()+1095) 'Format Red
'Condition 2
=C10 Format 'Green

lenze

 

[crosejr]

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!

 

[crosejr]

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

 

[crosejr]

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

 

[lenze]

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