Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Conditional Formatting dependent on multiple drop down lists in Word Conditional Formatting dependent on multiple drop down lists in Word
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 03-15-2022, 11:32 PM
Meme Meme is offline Conditional Formatting dependent on multiple drop down lists in Word Windows 11 Conditional Formatting dependent on multiple drop down lists in Word Office 2013
Novice
Conditional Formatting dependent on multiple drop down lists in Word 		 
Join Date: Mar 2022
Posts: 3
Meme is on a distinguished road
Default Conditional Formatting dependent on multiple drop down lists in Word
I have a table in word as part of a risk register which consists of 3 columns:


1. Consequence, 2. Likelihood and 3. Risk.
In the first table column (Consequence), I have a drop-down list: Negligible, Minor, Medium. Major, Extreme.
In the second table column (Likelihood), I have a drop down-list: Almost Certain, Likely, Possible, Unlikely, Rare.
This is where I'm stuck.
The third column (Risk) I want to be able to show the outcome of the items identified in Column 1 and 2. The outcome being L (Low), M (Medium), H (High), VH (Very High).
The background of each outcome being L = Green, M = Blue, H - Yellow and VH = Red.
I've attached the matrix for example.
Can Word do this?
Attached Images
File Type: jpg Risk Register Matrix.JPG (65.7 KB, 36 views)
Reply With Quote
  #2  
Old 03-16-2022, 12:43 AM
macropod's Avatar
macropod macropod is offline Conditional Formatting dependent on multiple drop down lists in Word Windows 10 Conditional Formatting dependent on multiple drop down lists in Word Office 2016
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
This has been addressed multiple times before. See, for example:
https://www.msofficeforums.com/word-...-controls.html
https://www.msofficeforums.com/word-...elections.html
https://www.msofficeforums.com/word-...different.html
https://www.msofficeforums.com/word-...own-lists.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 03-16-2022, 05:54 PM
Meme Meme is offline Conditional Formatting dependent on multiple drop down lists in Word Windows 10 Conditional Formatting dependent on multiple drop down lists in Word Office 2013
Novice
Conditional Formatting dependent on multiple drop down lists in Word 		 
Join Date: Mar 2022
Posts: 3
Meme is on a distinguished road
Default
Thank you so much for those links. Very helpful. I have adjusted my document to match the one from the links you provided, however, I can't get the Risk outcome to work on mine. I've attached the document, are you able to help?
Attached Files
File Type: dotm Risk Matrix.dotm (76.8 KB, 14 views)
Reply With Quote
  #4  
Old 03-16-2022, 10:21 PM
gmayor's Avatar
gmayor gmayor is offline Conditional Formatting dependent on multiple drop down lists in Word Windows 10 Conditional Formatting dependent on multiple drop down lists in Word Office 2019
Expert
  
Join Date: Aug 2014
Posts: 4,106
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default
As a starting point, document level events like
Code:
Private Sub Document_ContentControlOnExit(ByVal CCtrl As ContentControl, Cancel As Boolean)
should be in the ThisDocument module. They will not work from a standard module. I have not tested your code beyond establishing that it doesn't compile because you have an extra 'End With' line and a missing 'Next' line.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #5  
Old 03-16-2022, 11:14 PM
Meme Meme is offline Conditional Formatting dependent on multiple drop down lists in Word Windows 10 Conditional Formatting dependent on multiple drop down lists in Word Office 2013
Novice
Conditional Formatting dependent on multiple drop down lists in Word 		 
Join Date: Mar 2022
Posts: 3
Meme is on a distinguished road
Default
All fixed. Took me all day but I'm happy with the result.
Reply With Quote
  #6  
Old 09-27-2022, 08:45 PM
maggie.2017 maggie.2017 is offline Conditional Formatting dependent on multiple drop down lists in Word Windows 11 Conditional Formatting dependent on multiple drop down lists in Word Office 2016
Novice
  
Join Date: Sep 2022
Posts: 1
maggie.2017 is on a distinguished road
Default
@meme I am struggling with a similar problem and was wondering how you were able to fix your document. I'm very very new to using macros so all the articles are going over my head a bit.
Reply With Quote
  #7  
Old 10-02-2022, 07:33 AM
macropod's Avatar
macropod macropod is offline Conditional Formatting dependent on multiple drop down lists in Word Windows 10 Conditional Formatting dependent on multiple drop down lists in Word Office 2016
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default
Perhaps you should start a new thread, attaching a sample of your document and explaining exactly what problems you're having.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting dependent on multiple drop down lists in Word Multiple dependent dropdown lists in table with add new row option jeweldarby Word VBA 6 05-21-2022 04:37 PM
Excel Dependent Drop Down Lists john_red Excel Programming 2 02-15-2021 06:51 AM
Conditional Formatting dependent on multiple drop down lists in Word Conditional Formatting to activate Multiple Choices After Chosen From The Drop Down List UJ18 Word VBA 4 01-01-2020 01:59 AM
Dependent drop down lists bobbych Word 1 02-08-2013 04:38 PM
Dependent drop down lists in Word 2007 benbenasc Word VBA 0 08-24-2011 06:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:30 AM.

Contact Us - Privacy Statement - Top

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