Conditional Formating on a drop down list

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

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

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?
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?