Custom colour code with defined names?

If you need borders to change color, it will require a lot of code because of the way the borders are set up and use of merged cells. I'm not going to be able to get the time to do that for you.

However, here is a start that takes the table of colors, and applies them to the text in the table to illustrate what colors are being used. This doesn't do error checking on the hex values in the worksheet.