onditional formatting

  • Thread starter Thread starter CBT
  • Start date Start date
C

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
 
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.
 
Back
Top