| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I set up a conditional cell from a drop down list in Excel
Mon, Select: FormatConditional Formatting. The default for Condition 1 is "Cell Value Is". There is a dropdown arrow in that cell. When you click on the drop down, the other option is "Formula Is". Select that and the Formula Bar will appear to the right. Click on the formula bar and type = then select cell A7 (it will appear in your formula bar automatically with the $'s) then type ="Mileage" after $A$7. Remember that in order for the conditional format to apply to all the cells you want, you need to select them all before going to FormatConditional Formatting. Hope this clears it up for you. Regards, Steve -- SteveG ------------------------------------------------------------------------ SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571 View this thread: http://www.excelforum.com/showthread...hreadid=487711 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to Create a Conditional Drop down list | Excel Worksheet Functions | |||
| Creating a drop down list to change decimal value in another cell | Excel Worksheet Functions | |||
| How do I make a drop down list to pick from for a cell in Excel | Excel Discussion (Misc queries) | |||
| How do I create a combo drop down list in Excel? | Excel Worksheet Functions | |||
| Excel: how to formulate conditional cell references | Excel Worksheet Functions | |||
Threaded Mode
