Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
onditional formatting
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
onditional formatting
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
onditional formatting
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Another Greater Than Less Than onditional problem. | Excel Worksheet Functions | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions |