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
- 4104 reads
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago