nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

conditional formatting does not contain

andyc

I am trying to make a row highlight where the cell value does not contain L00 or X00 and highlight if anything else has been entered but cant seem to find how to do this. Any ideas

Find more posts tagged with

Comments

Andrée Starå

Hi Andy,

Would it work if you added the L00 and X00 as Not equal to and the Is not blank?

Hope that helps!

A possible workaround would be to add a so-called helper column with a formula checking a box if the above is true/false.

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Suzanne Raphael

Why would the conditional formatting tool include "contains" but not "does not contain?" Just ¯\_(ツ)_/¯ Why, why, why. Dumb.

KarinR

Hi @andyc ,

Not sure if this helps but at the bottom of the Set Condition screen there is an option for when condition is not met.

Nik Fuentes

@ker9 just for the record, that option only exists on the "select from a list" menu and not the "define custom criteria" menu. There is no way to replicate "does not contain" solely in the Set Condition menu. You would need a dedicated helper column.

Just making this note for anyone stumbling into this thread as a reference.

Sign in to join the conversation!

Quick Links

Trending discussions

Can't access issue submission
I have run into an interesting but small bug. When setting up an automation, the action 'change cell value' will allow you to select checkbox columns, but not checkbox columns that are the star or flag visual variant. Those can't be selected in the change value action. Now the real issue. I go to submit a bug report or…
Setting up the welcome and help screens.
Hello All, I am having difficulties uploading my information to the welcome and help screens. We are a Micro Soft 365 shop, using share point, and I am getting the error message that share point in refusing to connect. Whereas this appears to be a share point issue; I have reached out to our IT Department, and we cannot…
Contact List validation
Hi Everyone, I am managing a pipeline tracking sheet, and there's one intake form and one dynamic view connecting with this sheet. For the column "Branch Contact" and "Sales leader", I set the filed type as "Contact list" and the validation as "No validation". Once I input the username in the intake form, I go to the…