Bold a line

  • Thread starter Thread starter Thomas Roos
  • Start date Start date
T

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
 
Hi,

Select the row then

format|Conditional format - formula is

enter the formula

=$A1="Total"

Pick a colour - OK

Mike
 
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
 
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
 
Back
Top