>3 Conditional Formats

[Manosh]

Hi all

I'd like to automatically highlight the subtotal row for a set of data
based on the category of information.

For example a collection of "Apartments" is classified as
"Residential" and i'd like the row with residential to be
automatically highlighted for ease of reading.

Problem is i have more than 3 categories (Residential, Open Space,
Community Facilities, Commerical and so on)

Is there a way to do this on Conditional Format/ VBA? I am using excel
2003.

Many thanks
Manosh

 

[MartinW]

Hi Manosh,

You can have up to 30 conditions with Bob Phillips' CFPlus
Check this link.
http://www.xldynamic.com/source/xld.CFPlus.Download.html

HTH
Martin

 

[Lionel B. Dyck]

Hi Manosh,

You can have up to 30 conditions with Bob Phillips' CFPlus
Check this link.
http://www.xldynamic.com/source/xld.CFPlus.Download.html

HTH
Martin

This looks very good. Does this also mean that if I share the workbook with
others that they will have to install this add-in as well?

 

[Dave Peterson]

Yep.

This looks very good. Does this also mean that if I share the workbook with
others that they will have to install this add-in as well?

--
Lionel B. Dyck <><
AIM ID: lbdyck Yahoo IM: lbdyck
Homepage http://www.lbdsoftware.com/
Blog: http://randommgmt.blogspot.com/