PDA

View Full Version : List Conditional Formatting on Separate Sheet



vanhunk
09-07-2013, 02:42 PM
List Conditional Formatting on Separate Sheet:

Would it be possible to create a list of conditional formatting on a separate sheet, as indicated in the attachment?

The list will show the type of condition, the sheet and cell where the conditional formatting resides, plus the conditions and formatting of all the conditional formatting occurrences. (See attachment for example output)

Regards,
vanhunk

vanhunk
09-09-2013, 12:24 AM
snb, Any ideas? vanhunk

Aussiebear
09-09-2013, 12:29 AM
Have a read through this page on Chip Pearson's website. http://cpearson.com/excel/CFColors.htm

vanhunk
09-09-2013, 12:55 AM
Hi Aussiebear, Thank you for this information. I have a hard time to see how to use it to solve my original problem though. Regards, vanhunk

snb
09-09-2013, 01:37 AM
It's scuh a plethora of CF combinations.
Can you post a file that contains the CF's you are after ?