Sir Babydum GBE
05-19-2006, 06:24 AM
Hi again
Sheet 1, column A (1 to 100) has a list of codes which have all been formatted differently (cell and font colours, that is). (say "MyCode1" is red cell with white font; and "MyCode2" is light blue cell with black font etc etc)
Sheet 2 - all of it - has validation in every cell, so the user can only input one of the codes that appears on sheet 1.
How can I get excel to read the formatting in the cell that contains the identical code and apply the formatting into sheet 2 so that when the user inputs "MyCode1", for instance, it turns red with white font...
I know from Jake's KB article I could manually specify all the entries in the sheet code and assign colours - but there are two problems here:
1) I'm using Excel 97, and selecting an entry from a validated drop-down doesn't trigger a macro (unless I use Worksheet_Calculate - if I remember from a previous post)
2) I need flexiility - I need to be able to change colour schemes without going into the code and changing 100 lines each time.
Any help greatly appreciated. Thanks alot
Sir BD
Sheet 1, column A (1 to 100) has a list of codes which have all been formatted differently (cell and font colours, that is). (say "MyCode1" is red cell with white font; and "MyCode2" is light blue cell with black font etc etc)
Sheet 2 - all of it - has validation in every cell, so the user can only input one of the codes that appears on sheet 1.
How can I get excel to read the formatting in the cell that contains the identical code and apply the formatting into sheet 2 so that when the user inputs "MyCode1", for instance, it turns red with white font...
I know from Jake's KB article I could manually specify all the entries in the sheet code and assign colours - but there are two problems here:
1) I'm using Excel 97, and selecting an entry from a validated drop-down doesn't trigger a macro (unless I use Worksheet_Calculate - if I remember from a previous post)
2) I need flexiility - I need to be able to change colour schemes without going into the code and changing 100 lines each time.
Any help greatly appreciated. Thanks alot
Sir BD