Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-02-2017, 04:37 AM
will soar will soar is offline Cell Value and Colours Windows 10 Cell Value and Colours Office 2013
Novice
Cell Value and Colours
 
Join Date: Feb 2017
Posts: 14
will soar is on a distinguished road
Red face 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
Attached Files
File Type: xlsx MATRIX PIC EXCEL.xlsx (13.5 KB, 8 views)

Last edited by Pecoflyer; 12-03-2017 at 10:34 AM. Reason: Update
Reply With Quote
  #2  
Old 12-02-2017, 04:45 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Cell Value and Colours Windows 7 64bit Cell Value and Colours Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi and welcome
A sheet with the data would help, a photo is useless
What are L,S,RR ?
Quote:
On another sheet 1, I have three columns L x S = RR.
Where is that sheet?
__________________
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
Reply With Quote
  #3  
Old 12-02-2017, 05:40 AM
will soar will soar is offline Cell Value and Colours Windows 10 Cell Value and Colours Office 2016
Novice
Cell Value and Colours
 
Join Date: Feb 2017
Posts: 14
will soar is on a distinguished road
Default

L = likelihood
S = Severity
RR = Risk Rating

I have attached the file Risk Assessment sheet.

TY

B
Attached Files
File Type: xlsx Risk Assessment Sheet.xlsx (23.8 KB, 11 views)
Reply With Quote
  #4  
Old 12-04-2017, 06:15 AM
NBVC's Avatar
NBVC NBVC is offline Cell Value and Colours Windows 10 Cell Value and Colours Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

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.
Reply With Quote
  #5  
Old 12-04-2017, 12:36 PM
will soar will soar is offline Cell Value and Colours Windows 10 Cell Value and Colours Office 2016
Novice
Cell Value and Colours
 
Join Date: Feb 2017
Posts: 14
will soar is on a distinguished road
Default

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
Reply With Quote
Reply

Tags
colour values

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cell Value and Colours 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:22 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft