Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Create Drop Down list to change cell color
Register FAQ Search Today's Posts Mark Forums Read

Reply
 
Thread Tools Display Modes
  #1  
Old 08-20-2017, 11:42 AM
bksmith bksmith is offline Create Drop Down list to change cell color Windows 10 Create Drop Down list to change cell color Office 2016
Novice
Create Drop Down list to change cell color 		 
Join Date: Jun 2017
Posts: 5
bksmith is on a distinguished road
Default Create Drop Down list to change cell color

Is there a way to create a drop down list that will allow a user to select a color that will fill a CELL?

The cell may or may not contain any data besides just having the fill color in the cell.

I am wanting to ensure that the same fill color(s) shade (Green, Red, or Yellow) is used in selected cells.
Reply With Quote
  #2  
Old 08-20-2017, 05:50 PM
xor xor is offline Create Drop Down list to change cell color Windows 10 Create Drop Down list to change cell color Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,091
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default
Maybe like the attached.
Attached Files
File Type: xlsx RedGreenYellow.xlsx (9.8 KB, 11 views)
Reply With Quote
  #3  
Old 08-21-2017, 02:37 AM
xor xor is offline Create Drop Down list to change cell color Windows 10 Create Drop Down list to change cell color Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,091
xor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of lightxor is a glorious beacon of light
Default
Use this one instead.
Attached Files
File Type: xlsx RedGreenYellow_2.xlsx (9.7 KB, 15 views)
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create Drop Down list to change cell color looking to change cell color by typing number into the cell ibs Word Tables 1 11-22-2016 06:31 PM
create a drop down list jeffk Excel 3 09-10-2015 07:38 AM
Create Drop Down list to change cell color Change cell color when selection is made from a drop down list fedcco Excel 12 08-28-2012 10:43 PM
Change cell color everytime a value is selected in dropdown list angelica_gloria Excel 4 01-27-2012 06:47 PM
Create Drop Down List Box hbradshaw Word VBA 0 09-27-2010 06:24 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:07 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2023, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft