Conditional Formatting: 2003 to 2010

C

Clif McIrvin

I have a worksheet with conditional formatting that started life as
xl2003 .xls. Some while back I converted it to .xlsb (2010) format.
Today, I attempted to revise one of the conditional formatting rules and
I cannot find it!? The rule is being processed (the cell background is
getting changed per the rule) but when I go to "Manage Rules..." with
the range (either a range or a single cell) selected all I find is *one*
of the (two or three - I don't really remember) conditions.

Any suggestions?
 
C

Clif McIrvin

Disregard this question .... further digging revealed there were two
different processes operating on the column in question ... one was
conditional formatting, the other was in fact a VBA macro that was
explicitly setting the cell background. There was only a single format
condition.

My apologies for a poorly researched posting.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top