Conditional Formatting (for cells containing specific term)
 

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

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

Conditional Formatting (for cells containing specific term)
 

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

"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

Conditional Formatting (for cells containing specific term)
 

use formula is:

=NOT(ISERROR(SEARCH("Sum",A1,1)))
--
Gary''s Student - gsnu200719


"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

Conditional Formatting (for cells containing specific term)
 

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

Thank you all!

-Matt

Conditional Formatting (for cells containing specific term)
 

Thanks!!!

"Gary''s Student" wrote:

use formula is:

=NOT(ISERROR(SEARCH("Sum",A1,1)))
--
Gary''s Student - gsnu200719


"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

Conditional Formatting (for cells containing specific term)
 

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

Thanks,

Matt


"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

Conditional Formatting (for cells containing specific term)
 

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.
--
David Biddulph

"Matt" wrote in message
...
As a follow up question; is there anyway to make the entire row bold in
the
scenario below?

Thanks,

Matt

"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