Bold a line

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
 
M

Mike H

Hi,

Select the row then

format|Conditional format - formula is

enter the formula

=$A1="Total"

Pick a colour - OK

Mike
 
T

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
 
R

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formating bolded text exclusively. 0
Two lines in one in one line - How to do 2
Script MT bold 0
Bold paragraphs beginning with a number 0
Macro to concatenate with previous bold cell 0
Subject Line in MS Outlook Emails 0
Desperately need help for Word VBA to Fix Tables 12
BOLD WORDS IN CONCATENATE FORMULA 2

Top