#1
|
|||
|
|||
Cell Value and Colours
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 Last edited by Pecoflyer; 12-03-2017 at 10:34 AM. Reason: Update |
#2
|
||||
|
||||
Hi and welcome
A sheet with the data would help, a photo is useless What are L,S,RR ? Quote:
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
L = likelihood
S = Severity RR = Risk Rating I have attached the file Risk Assessment sheet. TY B |
#4
|
||||
|
||||
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. |
#5
|
|||
|
|||
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 |
Tags |
colour values |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Custom Colours | caz46 | PowerPoint | 4 | 06-16-2016 10:01 AM |
Custom Colours | caz46 | PowerPoint | 1 | 09-05-2014 05:50 AM |
Font colours | wolff | Word | 0 | 01-26-2010 08:03 PM |
Font Colours | Nissan Micrasoft | Word | 0 | 01-04-2010 06:10 AM |
Font Colours | fred bionics | PowerPoint | 1 | 10-18-2009 09:53 AM |