Format cell based on a range of other cells
 

I have been beating my brains out with this. I can't imagine this is too
hard, but I just cant make this work.

I have created a list of 100 items from S1 to S100 and named it "junk".
Cell F7 has a pull down list (DataVerificationListSource=junk) of these
items. I need to format F7 based on what item is selected. Items from
S1-S25 need to be red, S26-S50 blue, S51-S76 yellow, and S76-S100 no
formating.

Can anyone help me with this? Much thanks in advance.

Chris

Format cell based on a range of other cells
 

Try this:

Conditional Formatting

Condition 1 <RED
Formula Is:
=MATCH(F7,junk,0)<=25

Condition 2 <BLUE
Formula Is:
=AND(MATCH(F7,junk,0)=26,MATCH(F7,junk,0)<=50)

Condition 3 <YELLOW
Formula Is:
=AND(MATCH(F7,junk,0)=51,MATCH(F7,junk,0)<=76)

Biff

"Strike Eagle Loader" wrote in
message ...
I have been beating my brains out with this. I can't imagine this is too
hard, but I just cant make this work.

I have created a list of 100 items from S1 to S100 and named it "junk".
Cell F7 has a pull down list (DataVerificationListSource=junk) of these
items. I need to format F7 based on what item is selected. Items from
S1-S25 need to be red, S26-S50 blue, S51-S76 yellow, and S76-S100 no
formating.

Can anyone help me with this? Much thanks in advance.

Chris

Format cell based on a range of other cells
 

Man, that works perfect. Thanks a million.

Beers,

Chris

"T. Valko" wrote:

Try this:

Conditional Formatting

Condition 1 <RED
Formula Is:
=MATCH(F7,junk,0)<=25

Condition 2 <BLUE
Formula Is:
=AND(MATCH(F7,junk,0)=26,MATCH(F7,junk,0)<=50)

Condition 3 <YELLOW
Formula Is:
=AND(MATCH(F7,junk,0)=51,MATCH(F7,junk,0)<=76)

Biff

"Strike Eagle Loader" wrote in
message ...
I have been beating my brains out with this. I can't imagine this is too
hard, but I just cant make this work.

I have created a list of 100 items from S1 to S100 and named it "junk".
Cell F7 has a pull down list (DataVerificationListSource=junk) of these
items. I need to format F7 based on what item is selected. Items from
S1-S25 need to be red, S26-S50 blue, S51-S76 yellow, and S76-S100 no
formating.

Can anyone help me with this? Much thanks in advance.

Chris

Format cell based on a range of other cells
 

You're welcome. Thanks for the feedback!

Biff

"Strike Eagle Loader" wrote in
message ...
Man, that works perfect. Thanks a million.

Beers,

Chris

"T. Valko" wrote:

Try this:

Conditional Formatting

Condition 1 <RED
Formula Is:
=MATCH(F7,junk,0)<=25

Condition 2 <BLUE
Formula Is:
=AND(MATCH(F7,junk,0)=26,MATCH(F7,junk,0)<=50)

Condition 3 <YELLOW
Formula Is:
=AND(MATCH(F7,junk,0)=51,MATCH(F7,junk,0)<=76)

Biff

"Strike Eagle Loader" wrote
in
message ...
I have been beating my brains out with this. I can't imagine this is
too
hard, but I just cant make this work.

I have created a list of 100 items from S1 to S100 and named it "junk".
Cell F7 has a pull down list (DataVerificationListSource=junk) of
these
items. I need to format F7 based on what item is selected. Items from
S1-S25 need to be red, S26-S50 blue, S51-S76 yellow, and S76-S100 no
formating.

Can anyone help me with this? Much thanks in advance.

Chris