Excel atuo filling cells- question
 

I'm working with a spreadsheet (MS Office/Excel 2003) that someone else
set up, and certain cells, which I add to every day, will automatically
fill in with a background color when data is entered, which is pretty
nifty. But certail cells don't, even though they should (should meaning
that color-scheme wise it would be nice if they did). But I can't
figure out why they won't or how it's programmed to know when/and what
color to do that with. The strange thing is, I know these cells
(they're in a particular column) used to do that, and some of the other
cells *sometimes* don't auto fill the color, even though the same type
of data is put in everyday, it's sort of random. I've looked through
all the Cell and Column properties and can't figure out what settings
make this happen.
Any ideas?

Look up conditional formatting in help

--
Regards,

Peo Sjoblom


wrote in message
oups.com...
I'm working with a spreadsheet (MS Office/Excel 2003) that someone else
set up, and certain cells, which I add to every day, will automatically
fill in with a background color when data is entered, which is pretty
nifty. But certail cells don't, even though they should (should meaning
that color-scheme wise it would be nice if they did). But I can't
figure out why they won't or how it's programmed to know when/and what
color to do that with. The strange thing is, I know these cells
(they're in a particular column) used to do that, and some of the other
cells *sometimes* don't auto fill the color, even though the same type
of data is put in everyday, it's sort of random. I've looked through
all the Cell and Column properties and can't figure out what settings
make this happen.
Any ideas?