I have a list of 200 cells in Excel. I put in names and would like the text color in the cell or the background of the cell to change according to the name written. I use about 25 names.
migrated from stackoverflow.com Oct 17 '12 at 4:59
This question came from our site for professional and enthusiast programmers.
I suggest that you use Excel's conditional formatting feature. You can look at help to figure out how to do this. You can also find various documented examples
Conditional formatting would be best for this, but if you'd like a VBA alternative you can record a macro in the developer tab and edit it under "modules" in the "project" sidebar. Then under
You need to change the two dropdown menus above the text area, the left one needs to be set to
You can put as many
using select in code is not the best programming practice, but this is a small amount of data so it is alright. Hope this helps!