Hi

I have a Risk Assessment Matrix, which I am using as a Lookup Table
(using Vlookup & a Match function) to go and find the consequence and
the probability of an identified hazard and then return a assessment
number (ie, 1.1, 1.2, 3.1).  There are 4 colours on the matrix,
depending on whether they are High, Moderate, Low risks, etc.

I would like the cell that contains the vlookup, returning the
assessment rating, to also pick up the colour from the matrix (ie, Red
for High and Green for Low).

I know that conditional formatting will only allow 3 colours - I need
4 - and they need to be based on which assessment rating/number is
returned.

Any suggestions would be appreciated.

Thanks