Conditional color fill whole line...
 

I was wondering if there was a way to set up and conditional format so
that when it recognizes a name that it will fill that entire line with
a color.

EX. Everytime it sees the name Mike I want it to color that entire
line blue. I can get it fill the cell with the name Mike but I can't
figure how to get to to fill the rest of the cells in line with the
name Mike. Is it possible?


--
miwarren
------------------------------------------------------------------------
miwarren's Profile: http://www.excelforum.com/member.php...o&userid=24682
View this thread: http://www.excelforum.com/showthread...hreadid=390666

if all of the mikes are in one column you can use conditonal formating and
formula is.
if they could be in different cells, the easiest way to do it would depend
on how many cells thiy could be in.

"miwarren" wrote:


I was wondering if there was a way to set up and conditional format so
that when it recognizes a name that it will fill that entire line with
a color.

EX. Everytime it sees the name Mike I want it to color that entire
line blue. I can get it fill the cell with the name Mike but I can't
figure how to get to to fill the rest of the cells in line with the
name Mike. Is it possible?


--
miwarren
------------------------------------------------------------------------
miwarren's Profile: http://www.excelforum.com/member.php...o&userid=24682
View this thread: http://www.excelforum.com/showthread...hreadid=390666

Select the entire row - Conditional Formatting

Formula is =IF($A1="Mike",1,0)


miwarren Wrote:
I was wondering if there was a way to set up and conditional format so
that when it recognizes a name that it will fill that entire line with
a color.

EX. Everytime it sees the name Mike I want it to color that entire
line blue. I can get it fill the cell with the name Mike but I can't
figure how to get to to fill the rest of the cells in line with the
name Mike. Is it possible?


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=390666

There are instructions here for colouring a row based on the value in a
cell in that row:

http://www.contextures.com/xlCondFormat02.html

For your example, if Mike is in column B, use the formula:
$B2="Mike"

miwarren wrote:
I was wondering if there was a way to set up and conditional format so
that when it recognizes a name that it will fill that entire line with
a color.

EX. Everytime it sees the name Mike I want it to color that entire
line blue. I can get it fill the cell with the name Mike but I can't
figure how to get to to fill the rest of the cells in line with the
name Mike. Is it possible?




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html