Conditionally Bold a row
 

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

Conditionally Bold a row
 

Hi Dave,

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

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]


David wrote:
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

Conditionally Bold a row
 

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 he

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]


David wrote:
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

.

Conditionally Bold a row
 

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

wrote in message
...
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 he

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]


David wrote:
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

.