Previous Topic Next Topic

Conditional Formating on a drop down list

Closed
Emma - Dec 7, 2016 at 11:26 AM
 Blocked Profile - Dec 8, 2016 at 04:50 PM
Hello,

I would like to change the result of a option in a drop downlist based on a result from another cell.

A1=Optional B1=Green (option in the drop down list)
A1= Mandatory B1= Red (option from the drop down list)

2 responses

Answer 1 / 2
Blocked Profile
Dec 7, 2016 at 01:03 PM
Are you wanting the dropdown selection to change color, or the cell that is displaying the value?
Answer 2 / 2
Emma
Dec 8, 2016 at 03:04 AM
I don't want to change the colour of the cell but the result of the drop down box i.e auto choose one of the drop down options B1
Blocked Profile
Dec 8, 2016 at 04:50 PM
From what I have read, it will take the deployment of VBA. Do you have the developer tab unlocked on your Excel?

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
lava hard reset & factory reset
AVAY -
Har -

3 responses
WOW equipment return
aakash12345_0667 -
HelpiOS -

1 response
Snapchat block list
Jasonve -
dwebb -

1 response
Facebook Messenger - Suggested Friends
jadess_0462 -
Akajackal -

2 responses