Auto color fill in Excel - help

[gregf]

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?

 

[Tom Ogilvy]

Select a cell that does color, then go to

Format=>Conditional Formatting

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

 

[gregf]

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]

There are about only two ways to fill in the color on entry that I can think
of. One is with conditional formatting. The other is with a macro. this
could use the change event or it could use the calculate event. for an
event macro, right click on the sheet tab and select view code.

Nonetheless, I wouldn't expect a macro to have random failure like you
describe. I could see conditional formatting being destroyed by a paste
operation on the cell with the formatting.

If you don't find an code, then click in the upper right corner of the
border (upper left to cell A1) to select all cells, then do

Chip Pearson's page on events
http://www.cpearson.com/excel/events.htm

Edit=>goto=>Special and select "conditional formats" and under data
validation, select "All" (that should be the default). then click OK. If
it says No Cells Found, then you can be sure it isn't conditional
formatting.