Make drop-down icon visible when using Data>Validation
Make drop-down icon visible when using Data>Validation
(OP)
Hi,
I've made a list using the Data>Validation tool.
I was wondering if it was possible to make the drop-down icon (downward facing arrow) visible when the cell is not selected.
Thanks.
I've made a list using the Data>Validation tool.
I was wondering if it was possible to make the drop-down icon (downward facing arrow) visible when the cell is not selected.
Thanks.





RE: Make drop-down icon visible when using Data>Validation
RE: Make drop-down icon visible when using Data>Validation
There are other visual cues you can use. I like to make my input cells green. You can also use cell outline and a prompt like "<=choose one" to make the interface clearer. Attached a very tiny example.
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Make drop-down icon visible when using Data>Validation
Attached an example.
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Make drop-down icon visible when using Data>Validation
=====================================
Eng-tips forums: The best place on the web for engineering discussions.
RE: Make drop-down icon visible when using Data>Validation
Thanks for the suggestion iken.