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