View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tom Hutchins Tom Hutchins is offline
external usenet poster
 
Posts: 1,069
Default Conditional Formatting (for cells containing specific term)

Select all cells (click the box above the row numbers and to the left of the
column letters). Select Format Conditional formatting. Select "Formula is"
and enter the following in the formula box:

=(A1= "SUM")

Click the Format button and select Bold under Font style on the Font tab.
Click OK to close the Format Cells dialog, then OK to close the Conditional
Formatting dialog.

Hope this helps,

Hutch

"Matt" wrote:

Hello-

Is there a simple way to set up a conditional format for a worksheet that
makes every cell containing the text " Sum" bold?

I can't seem to figure this out on my own.

Thanks for any help that can be provided.

-Matt