complex color fill conditions- if statements or complex formula?

L

lilly8008

I have a row of dates that I wish to have flled once a condition has been
met. ( i have excel 2003)

Example
A1:A25 have various dates 01/02/09 thru 06/05/09.(dates will change
according to deadlines)

A124 has a date of 10/25/09.
When the A1:A25 fields dates change to say 10/25/09, I want the entire
column, A1:A124 to change a particular color.
 
T

T. Valko

When the A1:A25 fields dates change to say 10/25/09

When *all* of the dates are 10/25/09 or when *any* date is 10/25/09?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help w/ cell shading across entire column-when a criteria has been 1
dates inbetween 3
Converting dd:hh:mm to [h]:mm not working. 3
If then with a list 5
Capturing Trend Data over time 1
Excel 2002: How to fill up data in running order? 3
SUMIF Formula Help 8
IF and AND formula for date field 6

Top