| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional format a cell based on another range of cells | Excel Worksheet Functions | |||
| Formatting the color of a range of cells based on the value of one cell | Excel Worksheet Functions | |||
| how can I select a range of cells based on a value of a cell? | Excel Discussion (Misc queries) | |||
| how do i format a cell based on format of a range of cells? | Excel Discussion (Misc queries) | |||
| I want to format a cell based on an adjacent cells value | Excel Discussion (Misc queries) | |||
![Strike Eagle Loader[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
