Conditional Formatting: 2003 to 2010

  • Thread starter Thread starter Clif McIrvin
  • Start date Start date
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?
 
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

Similar Threads

Excel Conditional Formatting Removal 7
Conditional formatting in Excel 2010 2
Conditional Formating/Excel 2007 to 2003 1
Conditional Formatting Across Spreadsheets 3
Question about conditional formatting of zeros in Excel 0
excel 2007 - copying cells with conditional formating 2
Copying Conditional formatting 2
Apply Conditional Format to all sheets in same workbook 4

Back
Top