Format cell based on a range of other cells

  • Thread starter Strike Eagle Loader
  • Start date
S

Strike Eagle Loader

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 (Data>Verification>List>Source=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
 
T

T. Valko

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditionally formatting a cell based on other cell values 2
Force entry into cell, based on validation selection in adjacent cell 3
Names of workbook cell ranges not accepted with some signs 1
How to Color a Cell Based on a Range of Cells with Colors 1
Formula for changing cell format based on more than 3 values 3
Conditionally format a cell using a list of data defined in a rang 2
How do I color a cell based on cell text 1
Conditional formatting based on adjacent cell? 2

Top