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

Similar discussions

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

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Facebook Messenger - Suggested Friends
jadess_0462 -
Akajackal -

2 responses
Anyone's dm order all weird ?
Tillyleon111 -
toogleeful -

2 responses