Previous Topic Next Topic

Highlight one value in a dropdown menu of three responses

Solved/Closed
MeganN - Mar 17, 2017 at 12:31 PM
MeganNolf Posts 1 Registration date Friday March 17, 2017 Status Member Last seen March 17, 2017 - 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

Related:

1 response

Answer 1 / 1
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Mar 17, 2017 at 01:42 PM
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 Posts 1 Registration date Friday March 17, 2017 Status Member Last seen March 17, 2017
Mar 17, 2017 at 03:14 PM
Mazzaropi - Thank you so much! This was exactly what I needed :) I appreciate it.

Similar discussions

Ig stories from close friends to public
Darren -
zara -

31 responses
How to boot proline laptop
REDX -
Thulisile -

3 responses
Proline w763s BIOS Resetting
Neo -
carminabigue -

1 response
No device output installed on ProLine notebook
BossoPcWorkx -
HelpiOS -

1 response
Need to reset BIOS password on Proline U100
Rooijan -
NightwishGR -

2 responses