| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
complex color fill conditions- if statements or complex formula?
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
complex color fill conditions- if statements or complex formula?
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? -- Biff Microsoft Excel MVP "lilly8008" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| complex custom fill series with formula | Excel Discussion (Misc queries) | |||
| Extremely complex IF statements | Excel Worksheet Functions | |||
| complex if statements in excel | Excel Worksheet Functions | |||
| need help COMPLEX SUM /w conditions | Excel Worksheet Functions | |||
| need help COMPLEX SUM /w conditions | Excel Worksheet Functions | |||
Linear Mode
