get excel to automatically add fill color

[speedy18]

Ok I got numerous responses to my question on how to get excel to figur
out the two lowest values in a row of cells. Now I want excel to colo
those cells with a light yellow to allow for my members t
automatically figure out which two values were dropped.

I have each member on a row, each column represents a seperate bas
tournament and the weight each member caught at that tournament. Th
two lowest weights are now being subtracted from the total of al
tournaments but I want excel to basically highlight the cells that ar
being subtracted.


Please help out this excel dummy

Thank You
speed

 

[Bob Phillips]

Speedy,

Use Conditional formatting with 2 Formula Is Conditions,. So assuming that
data is in A1:A9, then

Select A1:A9
Goto Format>Conditional Formatting
Change Condition 1 to Formul Is
Add a formula of =A1=SMALL(A1:A9,1)
Click Format
Select the Pattern tab
Choose a colour
OK
Click Add >>
Change Condition 2 to Formula Is
Add a formula of =A1=SMALL(A1:A9,2)
Click Format
Select the Pattern tab
Choose the same colour
OK
OK


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[speedy18]

ok i tried that but it didnt do what i wanted it to do. it did caus
some cells to be filled with color but they werent the right cells an
instead of just the two lowest being colored it was all but two tha
were colored. I am at a loss, i knew i was gonna have to use some kin

 

[Bob Phillips]

Speedy,

It may be my error in the formula. Try

=A1=SMALL($A$1:$A$9,1)
and
=A1=SMALL($A$1:$A$9,2)

instead.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)