Tough one - Conditional Formatting

[Raj]

MVPs

I have a few questions

1. How do we add more than 3 conditional formats ? Macros ?? Any add-in tools available to make life easier

2. Also, can we write macros to trigger some action, not just color cells based on conditions being met

3. How can we get a count and statistics of the cells that have been highlighted due to conditional formats ? I have a big text file with thousands of lines of records and when I populate that into excel, based on some conditions, the cells would light up. Now I would need to get some statistics of which type of formats are most prevalent etc

4. Can I populate another sheet in the same workbook with free format text once again based on conditional formatting

Would greatly appreciate and applaud if anyone could hel

Best regard

Rajesh

 

[Frank Kabel]

Hi Raj

1. How do we add more than 3 conditional formats ? Macros ?? Any
add-in tools available to make life easier ?

actually you can apply 4 different formats (3 through the conditional
format dialog and one as default format). For more than 4 different
formats you need VBA code (process the workbook_change event).
If you only want to apply different font colors, you can define up to 6
different style. See:
http://www.mcgimpsey.com/excel/conditional6.html
for instructions how to do it
Further links for this topic:
http://www.cpearson.com/excel/cformatting.htm
http://www.contextures.com/xlCondFormat01.html

2. Also, can we write macros to trigger some action, not just color
cells based on conditions being met ?

also process the worksheet_change event. See
http://www.mvps.org/dmcritchie/excel/event.htm

3. How can we get a count and statistics of the cells that have been
highlighted due to conditional formats ? I have a big text file with
thousands of lines of records and when I populate that into excel,
based on some conditions, the cells would light up. Now I would need
to get some statistics of which type of formats are most prevalent
etc.

have a look at
http://www.cpearson.com/excel/colors.htm

4. Can I populate another sheet in the same workbook with free format
text once again based on conditional formatting ?

not sure what you mean with this question

HTH
Frank