Conditional formatting question (I think)

[mark hansen]

in a cell I have to following formula

=TODAY()-Y12&" Days Ago" and I get a display that says "3 days ago"

I want the cell to turn red when the number is greater than say 12 --- so for any statement that says 12 days ago (or more) the cell will turn red.

I tried conditional formatting by changing it to formula and entering today() - y12 >12 but couldn't get it work.

What am I getting wrong?

 

[jabba9]

in conditional formatting:

change to "formula is" and type =TODAY()-Y12>12

you might have to go back and remove all quotes (sometimes excel adds quotes, which can screw up conditional formatting)

Mike

 

[mark hansen]

Perfect!! The quotes were there too.

Thanks.