Well it looks like there is no way of programatically determining if
conditional formatting is applied, the best to be hoped for is determining if
conditional formatting should be applied based on the contents of the cell
and the conditional formatting conditions. I have it all in a spreadsheet, I
will provide a link once I get it onto my web pages. (In about 2 years) :)


"Ken Wright" wrote:

LOL :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"MarkTheNuke" wrote in message
...
Ok, you caught me there :@ I was looking around and I think I might have
found a cleaner solution using the Evaluate Method. However, it still
does
not answer my question about determined if Conditional Formatting is
applied,
I guess the answer is you can't, except by visual examination.
Mark
<snip