Risk Matrix Conditional Formatting
Good Morning,
I was wondering if someone could help me before i pull all my hair out.
I have a risk matrix made up of 3 columns, Likelihood, Consequence and Risk Rating. I have all the possible cobinations 24 of them e.g of one row Rare, Minor = Low
What i would like is under the columns have a drop downlist for Likelihood and Consequence and once you have made your selection your result (risk rating) is displayed.
I have attached an example so it makes sense.
Thanks for your help in advance.
See if attached helps
1) I created the DV list data beneath your table (Highlighted in Green)
2) altered the DV source to those ranges
3) this Array Formula (Cntrl+Shift+Enter,not just enter) in G3:
Formula:
Please Login or Register to view this content.
drag down
Hope this helps
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
That is exactly what i wanted.
Thanks for your help Dredwolf.
You are welcome
Please remember to mark the thread as solved if you are satisfied with your solution :
To mark thread "Solved", go to the top of the thread,click "Thread Tools",click "Mark as Solved"
I had to create the 2 droplist data and the key based on both responses..
Re: Risk Matrix Conditional Formatting
Was looking for exactly the same thing and this has saved me hours of frustration!!! Thanks so much!!
Many thanks Very handy!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks