Cell Value and Colours

[will soar]

Hello



I am seeking some help. I have attached a copy of an excel file that has a photo of a table. The table has details values of risk when you calculate X axis x Y axis. On another sheet 1, I have three columns L x S = RR. What I'd like to happen is that when the calculation of L x S will equal the colour and value in the RR cell that corresponds to the same value and colour in the table.

If any more information is need please ask

THANK YOU.

B

PS I'm operating excel 2106

[Pecoflyer]

Hi and welcome
A sheet with the data would help, a photo is useless
What are L,S,RR ?

On another sheet 1, I have three columns L x S = RR.

Where is that sheet?

[will soar]

L = likelihood
S = Severity
RR = Risk Rating

I have attached the file Risk Assessment sheet.

TY

B

[NBVC]

You can use conditional formatting to match the colours.

Select the ranges to affect and then go to Home|Conditional Formatting|New Rule

Use the "Format only cells that contain" and enter your lower and upper ranges for each colour.

[will soar]

Hello NBVC,

Thank You. Your instruction worked a charm and I have managed to get the colours working perfectly. I really appreciate your help and time.

Kind regards,


B