Formatting from Matrix

[becscott123]

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

 

[Bernie Deitrick]

bedscott,

Conditional formatting can offer three _conditional formats_, but a fourth format (simple
formatting) will be shown when none of the conditions are met.

HTH,
Bernie
MS Excel MVP