This might work ..

Assume the cells containing text such as: "ABC Sub Total " are in col A,
with the values sub-totalled in the adjacent col B

Select column B
Click Format Cond Formatting
Under Cond1, use:
Formula is| =ISNUMBER(SEARCH("Sub Total",A1))
Format to taste OK out

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Paul" wrote in message
...
Hi,

I'm using subtotals. I want the value that is the result of the subtotal
to
be bold. Can you help me with the syntax I use in the conditional
formating
dialogue box.
As the cell next to the cell containing the text "ABC Sub Total ", say
D20,
is empty, using a formula a long the lines of "if d20="". Normally column
D
contains values, so I could copy the conitional fomating down the sheet
and
only the sub total values would appear as bold.

Thanks for looking
Paul