Color filled in auto but from where
 

i have a spreadsheet that another person created for Project managemet of
dates over multiple release schedules. There is a formula
=IF(AND(EG$2=$B109, EG$2<=$C109),1,"") that places 1s or blanks in each
cell. Then something colors in each cell that has a 1 in it. I can't find
what is doing that. Any ideas?

Color filled in auto but from where
 

See if there is something under Format...Conditional formating...


"Cindi" wrote:

i have a spreadsheet that another person created for Project managemet of
dates over multiple release schedules. There is a formula
=IF(AND(EG$2=$B109, EG$2<=$C109),1,"") that places 1s or blanks in each
cell. Then something colors in each cell that has a 1 in it. I can't find
what is doing that. Any ideas?

Color filled in auto but from where
 

Hi!

Select one of the cells in question then goto FormatConditional Formatting.

You will probably see some settings there that are responsible for the
behavior you're describing.

Biff

"Cindi" wrote in message
...
i have a spreadsheet that another person created for Project managemet of
dates over multiple release schedules. There is a formula
=IF(AND(EG$2=$B109, EG$2<=$C109),1,"") that places 1s or blanks in each
cell. Then something colors in each cell that has a 1 in it. I can't
find
what is doing that. Any ideas?

Color filled in auto but from where
 

Thank you Gerry that was it. Yeah!!!!!!!

"GerryK" wrote:

See if there is something under Format...Conditional formating...


"Cindi" wrote:

i have a spreadsheet that another person created for Project managemet of
dates over multiple release schedules. There is a formula
=IF(AND(EG$2=$B109, EG$2<=$C109),1,"") that places 1s or blanks in each
cell. Then something colors in each cell that has a 1 in it. I can't find
what is doing that. Any ideas?