get excel to automatically add fill color
 

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

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

get excel to automatically add fill color
 

Speedy,

Use Conditional formatting with 2 Formula Is Conditions,. So assuming 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 in message
...
Ok I got numerous responses to my question on how to get excel to figure
out the two lowest values in a row of cells. Now I want excel to 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 seperate 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 that are
being subtracted.


Please help out this excel dummy

Thank You
speedy


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

get excel to automatically add fill color
 

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

get excel to automatically add fill color
 

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)

"speedy18 " wrote in message
...
ok i tried that but it didnt do what i wanted it to do. it did cause
some cells to be filled with color but they werent the right cells and
instead of just the two lowest being colored it was all but two that
were colored. I am at a loss, i knew i was gonna have to use some kind
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 assuming
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 in
message
...
Ok I got numerous responses to my question on how to get excel to
figure
out the two lowest values in a row of cells. Now I want excel to
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 seperate
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 that
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/