| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down Options
I have 2007....
"FSt1" wrote: hi assuming that you are talking about data validation...yes. but you would need to use conditional formating with it. or some heavy duty sheet code. with conditional formating you are limited to 3 conditions in 2003 and earlier. in 2007, you are limited by system resorces i.e. how much memory do you have. if you talking about a combo box, yes again but requires code and a tad bit more details on your part. regards FSt1 "Jenngv" wrote: Can I carry fill and font color to a cell from drop down data? For example; if I choose "A", the fill color of that cell will be red with an A. or If I choose "B", the font color of the B is blue. Thanks! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Columns Drop Down Options | Excel Discussion (Misc queries) | |||
| Drop down options | Excel Worksheet Functions | |||
| how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
| Drop-down menu options | Excel Discussion (Misc queries) | |||
Threaded Mode
