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

Report
-
Posts
1
Registration date
Friday March 17, 2017
Status
Member
Last seen
March 17, 2017
-
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

1 reply

Posts
1934
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
July 21, 2021
144
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
Posts
1
Registration date
Friday March 17, 2017
Status
Member
Last seen
March 17, 2017

Mazzaropi - Thank you so much! This was exactly what I needed :) I appreciate it.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!