Subtotals and Conditional Formatting

S

Studebaker

Hello,

I have a very big spreadsheet that is sorted by customer name. I have it
subtotaled by using Data>Subtotals. I want to bold each of the subtotal
values. In the example below, that would be the number, "6.00".
Ex:

ABC Co. 2.00
ABC Co. 4.00
Subtotal ABC Co. 6.00

I tried using Conditional Formatting to say bold every number with the
formula, "=SUBTOTAL(9,D9:D10)" b/c the #s that Excel subtotals, like the
"6.00" in the ex: above, have a formula in the cell with "=SUBTOTAL(...)".
It's not working.
The spreadsheet is too big to go through manually and bold the subtotals so
I need some kind of formula to put in the 'Formula is:' box of the
Conditional Formatting dialog box to do this for me.

Can someone help?

Thank you very much,
Studebaker

P.S. Thank you, Max for the help on my other conditional formatting question
 

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

Top