That is exactly my problem when I try to return the colorIndex property
after a cell has been conditionally formated I get a number like -4147.
During my research of this I discovered that number is from the table of
xlConstants. I might try that just for kicks. The color it is set to
after CF is stored somewhere.

Your recomended solution is right on, that would work, but now I have a
quest.




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

-4147? Do you mean -4142, which is xlColorindexNone, the cell default. All
cells start with this value so you might fail with what you try.

One day I am going to try and write a utility to test a CF colorindex, but
don't hold your breath.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"K Bro" wrote in message
...

That is exactly my problem when I try to return the colorIndex property
after a cell has been conditionally formated I get a number like -4147.
During my research of this I discovered that number is from the table of
xlConstants. I might try that just for kicks. The color it is set to
after CF is stored somewhere.

Your recomended solution is right on, that would work, but now I have a
quest.




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Or you could look at Chip Pearson's routine (he has already done it):

http://www.cpearson.com/excel/CFColors.htm
Conditional Formatting Colors

--
Regards,
Tom Ogilvy



Bob Phillips wrote in message
...
-4147? Do you mean -4142, which is xlColorindexNone, the cell default. All
cells start with this value so you might fail with what you try.

One day I am going to try and write a utility to test a CF colorindex, but
don't hold your breath.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"K Bro" wrote in message
...

That is exactly my problem when I try to return the colorIndex property
after a cell has been conditionally formated I get a number like -4147.
During my research of this I discovered that number is from the table of
xlConstants. I might try that just for kicks. The color it is set to
after CF is stored somewhere.

Your recomended solution is right on, that would work, but now I have a
quest.




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!