#1
|
|||
|
|||
Background color change with drop down list
Hi!
I'm trying to do multiple things but can't find the solution. 1. Quote:
2. Drop down list pick the option automatically (based on the date). Last edited by Wolfin2010; 01-31-2020 at 08:26 PM. Reason: Updating the status |
#2
|
|||
|
|||
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. |
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 |
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 |
Change cell color when selection is made from a drop down list | fedcco | Excel | 12 | 08-28-2012 10:43 PM |