What contains the text "Highway" or "Trans"? The "Value" of the drop-down or
the "Display Name"? If the "Value" of your drop-down is set to an ID or
something that does not contain the text you are looking for, conditional
formatting will not work like you want it to. You need to set the "Value" to
contain the entries you are checking against.
---
S.Y.M. Wong-A-Ton
"Roger0x1" wrote:
[Quoted Text] > Issue: I have a drop down list populating from a sql database. A series of
> entries begin with Highway (i.e. Highway PL03, Highway PL04, etc). I have a
> second series of entries that begin with Trans (i.e. Trans PL03, etc). If
> one of these two series are selected, I would like a second drop down box to
> become visible.
>
> On dropdown box2 I am using conditional formatting that says if box1 does
> not contain "Highway" hide this control.
>
> If I select any entry in box1 containing Highway the control remains hidden.
>
> What am I missing?
> Thanks.
|