I've looked at the cells that do color, and the Format-Conditional
Formatting window is empty, nothing set up...weird, since they do auto
coloring.


Tom Ogilvy wrote:
Select a cell that does color, then go to

Format=Conditional Formatting

and you should see how they are set up. No programming required.

--
Regards,
Tom Ogilvy

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.
Any ideas?