| 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 |
| 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)
Threaded Mode
