Thread: Bold a line
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default Bold a line

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

--
Rick (MVP - Excel)


"Thomas Roos" wrote in message
...
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
--
Tom


"Mike H" wrote:

Hi,

Select the row then

format|Conditional format - formula is

enter the formula

=$A1="Total"

Pick a colour - OK

Mike

"Thomas Roos" wrote:

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