S
Studebaker
I'm trying to make bold the subtotals in my spreadsheet I created via
Data>Subtotal... 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 Data>Subtotal...?
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
Data>Subtotal... 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 Data>Subtotal...?
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