Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-31-2020, 07:56 PM
Wolfin2010 Wolfin2010 is offline Background color change with drop down list Windows 10 Background color change with drop down list Office 2019
Novice
Background color change with drop down list
 
Join Date: Jan 2020
Posts: 1
Wolfin2010 is on a distinguished road
Question Background color change with drop down list

Hi!



I'm trying to do multiple things but can't find the solution.

1.
Quote:
When I pick the option from the D2 drop down list if it contains or starts with "OFF" B2 and C2 background to grey.
found the solution



2. Drop down list pick the option automatically (based on the date).
Attached Images
File Type: jpg Dropdown.jpg (144.8 KB, 16 views)
File Type: jpg Dropdown1.jpg (164.3 KB, 16 views)

Last edited by Wolfin2010; 01-31-2020 at 08:26 PM. Reason: Updating the status
Reply With Quote
  #2  
Old 02-02-2020, 11:59 AM
NoSparks NoSparks is offline Background color change with drop down list Windows 7 64bit Background color change with drop down list Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

If this were my project I'd color the B and C columns using Conditional Formatting.
The D column would have Data Validation all the way down and I'd use a macro to loop through the holiday dates of the Help sheet to overwrite the D cell validation for those particular dates.

Post the workbook instead of pictures and will have a go at it.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to change the selected area background color wordyg Word 0 01-28-2019 09:10 PM
Background color change with drop down list VBA change font color to background color donaldadams1951 Word VBA 6 05-31-2018 04:36 PM
Change excel background color, strange... sojiro Excel 7 04-18-2018 10:07 AM
Create Drop Down list to change cell color bksmith Excel 2 08-21-2017 02:37 AM
Background color change with drop down list 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:41 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