Excel 2003: Conditional Formatting with Subtotals

[oceanmist]

I have a report in which I want to use conditional formatting and subtotals
on the same column. I want to highlight in yellow the amounts in that column
that are greater than $500. After that, I want to subtotal the columns by the
category which is in another column.

The problem is that the subtotal figure gets the conditional format, too, as
it invariably is greater than $500. How do I use conditional formatting on
the detail figures only and not the subtotals?

 

[Dave Peterson]

Maybe you can add check to your conditional formatting rule:

=and(countif($a2,"*total*")=0,$b2>500)

Assumes that column A is the column that holds the total indicator and column B
is the column you want to check.