I have a drop-down list in a cell that contains 6 items (for arguments sake named Item 1, Item 2, Item 3, Item 4, Item 5, Item 6). I would like the whole row to change colour depending on what Item was selected: it would change to Blue if Item 1 were selected; Green if Item 2 selected and so on.
I am aware that I may need to have a 'Select Case' in VB to list the items along with the colour index numbers alongside, for the 6 listed Items.
Many thanks for taking your valuable time to read this and any help much appreciated.
Paul S
Bookmarks