mec1981's blog
Changing colors in Excel using VB
Submitted by mec1981 on 28 December, 2011 - 15:27I have been asked to create a training spreadsheet at work that is to be colour coded to individual levels. I have entered the below VB string but have used educational guesses so far as I have no training in VB.
At present the Sheet cells have a validation list where members of the team can only select 1 of 5 skill set options, however the background colour does not automatically update unless you actually activate the cell after making your selection. Can you please advise how I can get this to automatically update with each change?
»
- 8 comments
- Read more
- 4149 reads

Recent comments
5 years 50 weeks ago
6 years 36 weeks ago
6 years 47 weeks ago
6 years 50 weeks ago
6 years 51 weeks ago
7 years 5 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago
7 years 13 weeks ago