onditional formatting

[CBT]

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

 

[Grey Newt]

Most of your code can be got using the macro recorder.

Press F5, click Special, then select Conditional formatting. This will select all cells with conditional formatting.
You then need to walk through selected cells (for each cell in selection...) and lift out the properties that you want (there will be many !). Get these properties by recording yourself adding conditional formatting to a cell then disect the code.

 

[Gord Dibben]

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