Bold a line

[Thomas Roos]

I want to bold an entire row if the cell in the first column contains the
word Total.
How would I do that?
Thanks

 

[Mike H]

Hi,

Select the row then

format|Conditional format - formula is

enter the formula

=$A1="Total"

Pick a colour - OK

Mike

 

[Thomas Roos]

Let me clarify this a little more.
I have lots of rows that I want to evaluate.
The cell will contain more than the word Total
The column of text will have more than one row with the word Total in it.

How do I solve this problem.
Thanks

 

[Rick Rothstein]

Select all your rows that can (or could eventually) have data in them and
use this formula in the Conditional Formatting dialog (don't forget to
select the Bold property for the Format/Font tab)...

=COUNTIF(1:1,"*total*")>0