Conditional format in excel 2003 based on another cell?

[wx4usa]

Is there a way to conditionally format a cell based on a date in
another cell?

In other words, cells A1:A10 contain data. C15 contains a date. If the
date is in the past, can I change the formatting in cells A1:A10? Or
any other cells for that matter?

 

[Guest]

You sure can. Try this
Select A1:a10 and Format -> Conditional Format

Formula Is =$C$15 < today()

And set the format as you wish.

HTH,
Barb Reinhardt

 

[Guest]

Hi,

Select A1:A10 then

Format|conditional formula
Select formula is
Paste this in and choose a colour

=$C$15<=TODAY()

Mike

 

[wx4usa]

You sure can. Try this
Select A1:a10 and Format -> Conditional Format

Formula Is =$C$15 < today()

And set the format as you wish.

HTH,
Barb Reinhardt

My cells A1:A10 do not contain dates. I just want them to go black
when a certain date in C15 has been exceeded. Is that possible?

 

[wx4usa]

Ok, I get it now, I'm a bit slow. It works great. Thanks so much. I
appreciate your help.