Cell shading based on conditions

B

Brad1982

My apologies I forgot change b1 to c4 in the formula, it works now :)

I would like this shading to work for each row individually, is ther
an easy way to format all the rows at once while remaining independen
of eachother.

My data is over 80 names with corresponding numbers.

Names are in cells A4:A152 While their corresponding numbers range fro
C4:Q4

A4.........................J4.......................Q4
Joe.........................3......................45
A152.....................j152....................Q152
Bob.......................6.........................63

the formula that worked for the individual row was: =C4=MAX($B$4:$Q$4)

Thanks for your hel
 
D

Dave Peterson

Select C4 through Q(whatever)
and with C4 the activecell, use this formula:

=C4=MAX($C4:$Q4)

(I dropped a couple of $ signs)
 
Top