Thread: Cell Value and Colours
View Single Post
 
Old 12-02-2017, 04:37 AM
will soar will soar is offline Windows 10 Office 2013
Novice
  
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