Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Create Drop Down list to change cell color
Register FAQ

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,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
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,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
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 »


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 04:16 PM.

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