Excel 2003: Conditional Formatting with Subtotals

O

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?
 
D

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

subtotal formatting 0
Changing row background from external program 0
Conditional formatting with dates 7
Document Merge Formatting Issue 0
Conditional formatting with two columns 0
Mail Merge Directory Conditional Page Break 0
Conditional Formatting Pivottables 0
Conditional Formatting using Traffic Lights 6

Top