I'm trying to make bold the subtotals in my spreadsheet I created via
DataSubtotal... using a formula in Conditional Formatting.
Below is a copy of a previous post of mine and I don't understand the answer
given to me.
How could =AND(ISNUMBER(SEARCH("total",A2)),ISERROR(SEARCH(" grand",A2)))
bold the subtotals in my spreadsheet that I created via DataSubtotal...?
How would the SEARCH and ISNUMBER functions help bold my subtotals in my
spreadsheet?
Can someone help?


P.S. I don't need to bold Grand Totals


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