Thanks for the pointers. Bottom line is that you can't do it. Chip
Pearson's marco's parse the formulae and test which condition is set but,
as noted, this won't work unless the formula have absolute references. I
have many hundred different cells who's colour is set according to a
conditional format statement which include relative references to
neighbouring cells, and it is impractical to convert these to absolute
references. Seems very odd to me that you can't access this information.

--
Message posted via http://www.officekb.com