Conditional Formatting (for cells containing specific term)

[Guest]

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

 

[Guest]

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

 

[Guest]

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)))

 

[Guest]

use formula is:

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

 

[Guest]

Got it to work... thanks to the help provided here.

Thank you all!

-Matt

 

[Guest]

Thanks!!!

use formula is:

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

 

[Guest]

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

Thanks,

Matt

 

[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.