Prev: Formula issue.
Next: How do I remove data in a row in excel without losing all data in
From: JEA on 29 Apr 2010 13:35
I am trying to conditionally format a column to have the text (which are
dates) to turn red/bold a year from the date in the cell. I know how to
bold/red, I just can't figure out how to set it for a year from the date in
each particular cell. The dates are different in each cell. Thank you!
From: Luke M on 29 Apr 2010 13:55
1 year from...which date/cell? Assuming you mean today, your CF formula
would be:

=B2>TODAY()+365

If its a particular cell you're comparing, make it:
=B2>$A$1+365

--
Best Regards,

Luke M
"JEA" <JEA(a)discussions.microsoft.com> wrote in message
news:0C1F2C30-E6AA-40B2-A678-A181D4F167E8(a)microsoft.com...
>I am trying to conditionally format a column to have the text (which are
> dates) to turn red/bold a year from the date in the cell. I know how to
> bold/red, I just can't figure out how to set it for a year from the date
> in
> each particular cell. The dates are different in each cell. Thank you!


 | 
Pages: 1
Prev: Formula issue.
Next: How do I remove data in a row in excel without losing all data in