Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Populate Adjacent Cells based on Pull Down Selection
I have a spread sheet where col A is a "Level Of Training" named range
("LOT") pull down selection built in the Validation List box. Dependent upon LOT selected for that row, I need the col B (labeled T1), col C (labeled T2), etc through col G (labeled T6) to be populated with a number (0-5). The number is put in each column again is dependent on the LOT selection. Example: LOT= TSTA, col B = 1, col C = 3, ... Col A B C D... TSTA 1 1 3... GS 3 2 1... .. .. Now for the fun part....if the number is 0 (zero) then I want the font color to be light grey. I tried to do a case select statement but just get 0 in all cells.... please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populate Adjacent Cells based on Pull Down Selection | New Users to Excel | |||
How to populate a cell with numeric value based on textselected from pull down in adjacent cell? | Excel Worksheet Functions | |||
populate fields based upon pull down lists | Excel Worksheet Functions | |||
Auto populate several cells based on a selection from drop down li | Excel Discussion (Misc queries) | |||
need to populate several cells based on drop down menu selection | Excel Discussion (Misc queries) |