Conditional Formatting for Linked Selection Field

Support
1

Hello everyone,

I have a linked Selection Field to get order no. from another sheet, I want to hide an action button if this field is not empty.

However the selection available in the conditional formatting settings, it just allow me to select “contains” and “does not contain”, then a list of all my orders.

How do I set the condition to “is not empty”?

2

Hi,

Please leave the value part blank in your conditional formatting settings to represent “empty”.

image
image821×498 11.7 KB

3

image

This is what I see.

4

Hi,

For a multiple-select field, please create another field and apply the ISBLANK formula to reference the multiple-select field to determine whether the multiple-select field is blank or not. Once that is done, please apply your conditional formatting based on the new ISBLANK field.