Conditional color fill whole line...

[miwarren]

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

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

 

[Guest]

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

 

[Morrigan]

Select the entire row -> Conditional Formatting

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

 

[Debra Dalgleish]

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"