Color filled in auto but from where

[Cindi]

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?

 

[GerryK]

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

 

[Biff]

Hi!

Select one of the cells in question then goto Format>Conditional Formatting.

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

Biff

 

[Cindi]

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

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