Report

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

Helpful
+0
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.
OK

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.
Reply
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!