0

I have a lookup column for Tabs:

Major
Sub-1
Sub-2
Sub-3
Technical
Pricing

I need to setup conditional formatting so the row color changes with the level of tab selected. I can do this with drop down columns, but it is not working with lookup?

Is there a work around for this? If not how do I have a drop down that will not give me an error if there is no blank option?

0

Lookup column data is stored in format ID:#stringvalue. Hence if you do an equal comparison, it will fail.

The best option is to use contains

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.