I would like to use VBA to change sheet tab color based on a name value in cell N1.
Name: Paul, RGB: 204,192,218
Name: Don, RGB: 230,185,184
Name: George, RGB: 252,213,180
Based on name of Paul, Don, or George in cell N1, I would like to change the sheet tab color to the respective RGB color...