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!