Populate Adjacent Cells with value after selecting from dropdown

A

Ambassador

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

A For Each in Range... with a .Find(what:="TJ", ... in it problem 15
Six columns randon no.'s no dupes 6
Counting Criteria Values with For Loop 3
Format sheet based on column contents 1
Compare Names in a column and create single list with adjacent vla 3
Locking/unlocking cells based on column headers 5
Find largest value in column with 2 criteria 1
Eliminating non-matching cells 4

Top