Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-02-2017, 11:11 AM
PLeo PLeo is offline Changing background colour based on dropdown choice Windows 7 64bit Changing background colour based on dropdown choice Office 2010 64bit
Novice
Changing background colour based on dropdown choice
 
Join Date: Aug 2017
Posts: 3
PLeo is on a distinguished road
Default Changing background colour based on dropdown choice

Greetings,

I would like to have the background colour for a table cell change depending on the choice from a dropdown list. I've uploaded a document as a sample. I would like to do this to other documents (I'm developing Assessment sheets for my class) as well.

I am a complete novice when it comes to using Macros and I have tried to make sense of several explanations of how to do this but I have met my match. Can anyone help a newbie?



Thanks
Attached Files
File Type: docx Latin 9 Capitulum I Tracking Sheet 2017.docx (48.9 KB, 13 views)
Reply With Quote
  #2  
Old 08-02-2017, 03:17 PM
macropod's Avatar
macropod macropod is offline Changing background colour based on dropdown choice Windows 7 64bit Changing background colour based on dropdown choice Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

See: https://www.msofficeforums.com/word-...html#post47254
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 08-03-2017, 07:40 AM
PLeo PLeo is offline Changing background colour based on dropdown choice Windows 7 64bit Changing background colour based on dropdown choice Office 2010 64bit
Novice
Changing background colour based on dropdown choice
 
Join Date: Aug 2017
Posts: 3
PLeo is on a distinguished road
Default Thanks

Thank you Macropod!

Even I was able to adapt with ease what you made available. Thank you so much!
(I had to abandon Orange since there is no Word Constant for it but it is worth the sacrifice.)
Attached Files
File Type: docm Latin 9 Capitulum I Tracking Sheet 2017.docm (130.2 KB, 20 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing background colour based on dropdown choice Hide/Unhide a Block of Text Based on Choice Selection inquirer Word VBA 7 09-22-2014 04:41 PM
Changing background colour based on dropdown choice Adding text to after a bookmark based on drop down menu choice ksigcajun Word VBA 6 06-10-2014 09:39 AM
Changing background colour based on dropdown choice changing colour in clipart iantommycampbell PowerPoint 1 03-28-2011 12:59 AM
changing object colour kaur1 PowerPoint 0 02-23-2011 07:18 AM
Trying to clear the background colour from a theme ezekiel181 Word 1 11-14-2010 07:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:05 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