Background color change with drop down list

		Microsoft Office Forums > Microsoft Excel > Excel
Background color change with drop down list

01-31-2020, 07:56 PM

Wolfin2010 Wolfin2010 is offline

Windows 10 Background color change with drop down list

Office 2019

Novice

Join Date: Jan 2020

Posts: 1

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

	Dropdown.jpg (144.8 KB, 18 views)
	Dropdown1.jpg (164.3 KB, 18 views)

Last edited by Wolfin2010; 01-31-2020 at 08:26 PM. Reason: Updating the status

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

Other Forums: Access Forums

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