Syntax for Conditional Formats

[Guest]

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

 

[William]

Hi Paul

If it is only the subtotal rows hat contain formulae, select one cell on the
worksheet, press F5 , select "Special" and then "Formulae" from the dialog
box.. You can then apply bold formatting to those selected cells.

-----
XL2003
Regards

William

(e-mail address removed)

 

[Max]

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