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

Ask a question MeganN - Last answered on Mar 17, 2017 at 03:14 PM by MeganNolf

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

plus moins
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.

Please, tell us if it worked for you.
I hope it helps.
Belo Horizonte, Brasil.
Marcílio Lobão
MeganNolf 1Posts 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.
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!