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?