Subtotals and Conditional Formatting
 

Hello,

I have a very big spreadsheet that is sorted by customer name. I have it
subtotaled by using DataSubtotals. 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

Subtotals and Conditional Formatting
 

Do you want the "Grand Total" formatted also or *just* the subtotals?

http://img527.imageshack.us/img527/9642/formatrx2.jpg

For just the subtotals:

Conditional Formatting
Formula Is:

=AND(ISNUMBER(SEARCH("total",A2)),ISERROR(SEARCH(" grand",A2)))

To include the Grand Total:

=ISNUMBER(SEARCH("total",A2))

Biff

"Studebaker" wrote in message
...
Hello,

I have a very big spreadsheet that is sorted by customer name. I have it
subtotaled by using DataSubtotals. 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