I have cell B6 which has Vehicle Registration Number in. Example: CE63ANX. The spec type is 6. There are 7 different specs and each has a different colour to indicate vehicle Max Train Weight.
I have a lookup formula that looks for that vehicle reg in another table in a separate sheet and returns the spec number in cell C6.
I want Cell B6 to be blue.
Any idea how I can achieve this please