Excel – Color cells in Excel based on certain values

microsoft excel

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.

Best Answer

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

Example: SU488776 example