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

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.

ker9

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.