PC Review


Reply
Thread Tools Rate Thread

Conditional Formatting: 2003 to 2010

 
 
Clif McIrvin
Guest
Posts: n/a
 
      1st Dec 2010
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?

--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)


 
Reply With Quote
 
 
 
 
Clif McIrvin
Guest
Posts: n/a
 
      2nd Dec 2010
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.

--
Clif

"Clif McIrvin" <(E-Mail Removed)> wrote in message
news:id6jju$i62$(E-Mail Removed)...
>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?
>
> --
> Clif McIrvin
>
> (clare reads his mail with moe, nomail feeds the bit bucket :-)
>
>




--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)


 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
little off topic, but with excel 2010 conditional formatting properties will be accessible through vb Gary Keramidas Microsoft Excel Programming 1 14th Aug 2009 04:42 PM
conditional formatting in excel 2003 GrouchyMammy Microsoft Excel Worksheet Functions 5 13th Apr 2009 03:05 AM
Conditional Formatting 2003 confused!! Microsoft Excel Charting 4 25th Nov 2008 02:13 PM
Conditional Formatting Not working (xls 2003) =?Utf-8?B?QmV0dGVyZ2FpbnM=?= Microsoft Excel Programming 9 12th Nov 2004 04:07 PM
Excel 2003 - conditional formatting spatten Microsoft Excel Worksheet Functions 1 26th May 2004 04:53 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:32 AM.