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
of conditional formatting but i just cant seem to hit on it.Bob Phillips wrote:
*Speedy,

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

Select A1:A9
Goto FormatConditional 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 " wrote i
message
...
Ok I got numerous responses to my question on how to get excel t
figure
out the two lowest values in a row of cells. Now I want excel t
color
those cells with a light yellow to allow for my members to
automatically figure out which two values were dropped.

I have each member on a row, each column represents a seperat
bass
tournament and the weight each member caught at that tournament
The
two lowest weights are now being subtracted from the total of all
tournaments but I want excel to basically highlight the cells tha
are
being subtracted.


Please help out this excel dummy

Thank You
speedy


---
Message posted from http://www.ExcelForum.com/


--
Message posted from http://www.ExcelForum.com