Conditional Formatting (for cells containing specific term)

M

Matt

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
 
T

Tom Hutchins

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
 
D

Duke Carey

For cell A1, use Formula is and use this formula (not case sensitive)

=NOT(ISERROR(SEARCH(" sum",A1,1)))

or this one (case sensistive)

=NOT(ISERROR(FIND(" sum",A1,1)))
 
M

Matt

As a follow up question; is there anyway to make the entire row bold in the
scenario below?

Thanks,

Matt
 
D

David Biddulph

Yes. Read the help for conditional formatting.

And depending on whether the cell contains only the text " Sum" or whether
it might contain a longer string with the string " Sum" within it, then you
may need to look at help for finding text.
 
Top