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