Conditionally Bold a row

[David]

I would like to bold out an entire row if the value in
column a has the word total in it. Any ideas...


Thanks in advance,

Dave

 

[Jake Marx]

Hi Dave,

Conditional Formatting is what you're looking for. Chip Pearson has a good
explanation here:

http://www.cpearson.com/excel/cformatting.htm

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

 

[Guest]

This works on a specific cell. How do I extend this
functionality to the entire row ?

-----Original Message-----
Hi Dave,

Conditional Formatting is what you're looking for. Chip Pearson has a good
explanation here:

http://www.cpearson.com/excel/cformatting.htm

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

I would like to bold out an entire row if the value in
column a has the word total in it. Any ideas...


Thanks in advance,

Dave

.

 

[Tom Ogilvy]

For example, select rows 1 to 20 with cell a1 as the active cell.

In conditional formatting change Cell Value is to Formula is

=Countif($A1,"*total*)

Set your format

OK out.

So you write the formula so it is appropriate for the activecell and use
combinations of relative and absolute references so it is adjusted properly.
In the above example, column A is made absolute so the formula doesn't
adjust that reference.

Regards,
Tom Ogilvy

This works on a specific cell. How do I extend this
functionality to the entire row ?

-----Original Message-----
Hi Dave,

Conditional Formatting is what you're looking for. Chip Pearson has a good
explanation here:

http://www.cpearson.com/excel/cformatting.htm

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]

I would like to bold out an entire row if the value in
column a has the word total in it. Any ideas...


Thanks in advance,

Dave

.