Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-18-2022, 11:13 AM
templeowls templeowls is offline Drop down list change color of a table cell? Windows 10 Drop down list change color of a table cell? Office 2016
Novice
Drop down list change color of a table cell?
 
Join Date: Mar 2019
Posts: 6
templeowls is on a distinguished road
Default Drop down list change color of a table cell?

I have a simple dropdown list in a table cell and it contains the response "yes" and "no".



I was wondering if its possible to have the cell background color automatically change based on the selection. So if the user selects yes, the background of the cell changes to green. Or to red if no is selected.

Any thoughts?
Reply With Quote
  #2  
Old 05-18-2022, 11:26 AM
Charles Kenyon Charles Kenyon is offline Drop down list change color of a table cell? Windows 10 Drop down list change color of a table cell? Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,083
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Why not use a checkbox Content Control? You can customize the checked and unchecked icons so that it is easily visible when checked.
Reply With Quote
  #3  
Old 05-18-2022, 02:58 PM
macropod's Avatar
macropod macropod is offline Drop down list change color of a table cell? Windows 10 Drop down list change color of a table cell? Office 2016
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

Quote:
Originally Posted by Charles Kenyon View Post
Why not use a checkbox Content Control?
The problem with checkboxes is you can't tell whether their continuing existence in the default state is because someone forgot to verify them...
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 05-18-2022, 02:59 PM
macropod's Avatar
macropod macropod is offline Drop down list change color of a table cell? Windows 10 Drop down list change color of a table cell? Office 2016
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

Quote:
Originally Posted by templeowls View Post
I have a simple dropdown list in a table cell and it contains the response "yes" and "no".

I was wondering if its possible to have the cell background color automatically change based on the selection. So if the user selects yes, the background of the cell changes to green. Or to red if no is selected.
For Content Control & Formfield Conditional Formatting, see: https://www.msofficeforums.com/word-...html#post47254
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Background color change with drop down list Wolfin2010 Excel 1 02-02-2020 11:59 AM
Drop down fields in Word - Change color of cell, then add text BernaDev202 Word VBA 3 08-09-2018 02:29 PM
Macro to change an RGB table cell shading color to another RGB color David Matthews Word VBA 4 05-29-2018 02:45 PM
Create Drop Down list to change cell color bksmith Excel 2 08-21-2017 02:37 AM
Drop down list change color of a table cell? Change cell color when selection is made from a drop down list fedcco Excel 12 08-28-2012 10:43 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:48 AM.


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