Highlight one value in a dropdown menu of three responses [Solved/Closed]

MeganN - Mar 17, 2017 at 12:31 PM - Latest reply: MeganNolf 1 Posts Friday March 17, 2017Registration date March 17, 2017 Last seen
- Mar 17, 2017 at 03:14 PM
Hello,

I have a template where we are asking for responses with a drop down that includes Y, N, and N/A. We want to highlight all N answers in yellow within the dropdown, so that if a person selects N, they see the highlight and proceed to give additional detail. How can I do this so that just the N's in the dropdowns are highlighted yellow?

Thank you

See more 

2 replies

Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Mar 17, 2017 at 01:42 PM
0
Thank you
MeganN, Good afternoon.

Suppose you want your dropdown at D4 cell.

Select D4 cell
Conditional Format Menu -->
Using formula -->
Type: =D4="Y"
Format color as you want.
OK

Please, tell us if it worked for you.
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
MeganNolf 1 Posts Friday March 17, 2017Registration date March 17, 2017 Last seen - Mar 17, 2017 at 03:14 PM
Mazzaropi - Thank you so much! This was exactly what I needed :) I appreciate it.