Conditional format in excel 2003 based on another cell?

  • Thread starter Thread starter wx4usa
  • Start date Start date
W

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?
 
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
 
Hi,

Select A1:A10 then

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

=$C$15<=TODAY()

Mike
 
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
Click to expand...

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?
 
Ok, I get it now, I'm a bit slow. It works great. Thanks so much. I
appreciate your help.
 
Back
Top