Conditional formatting - font and background should disappear

Joerg Schmidt

Hi,

I want the font and background to disappear when cells show "Invalid Data Type". But it doesn´t work ?

Font and background stay black/grey - as shown in following screenshot.

Any idea ?

Andrée Starå

@Jörg Schmidt Novum Hospitality

I have to ask! ;)

Strange!

Try changing the colors to something that will show that the logic is working to start with. Ok?

Andrée Starå

Hi Jörg,

The way conditional formatting works is it prioritizes them top to bottom, so try moving it up, and it should work.

Did that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer! 

Joerg Schmidt

Hi Andree,

unfortunately not. I moved the rule on top of the 13 rules but font/background stay in black

Andrée Starå

Did you select the color in the color picker manually?

Joerg Schmidt

Yes ;-)

Andrée Starå

@Jörg Schmidt Novum Hospitality

I have to ask! ;)

Strange!

Try changing the colors to something that will show that the logic is working to start with. Ok?