Christoph

Check out Chip Pearson's website for code dealing with CF cells. May be
something there you can use.

http://www.cpearson.com/excel/CFColors.htm

Gord Dibben XL2002

On Sat, 8 Nov 2003 09:09:44 +0100, "CBT" wrote:

Hi

I have the problem to find cells in big spreadsheets which have conditional
formats. Is there a possibility to find these cells with a VBA macro and if
YES is it possible to read the conditions and formats of these cells in
order to write them on an other place in the workbook down. Has anybody an
idea how I could do this.
Thank you very much in advance for your help.

Kind regards
Christoph