Conditional Formatting doesn't work as expected!

[cangokturk]

Hi,

I want to apply formatting by condition but it doesn’t work as expected or I miss something.

When I test the formula, expression results are just right but it doesn’t apply right formatting it applies like all conditions are TRUE.

Thanks for help.

[hru]

Are you trying to apply Formatting rule?

Please screen shoot the formatting rule and what is your expectation to make it work?

[cangokturk]

Thank you for your response, here is the screenshot.

[Bahbus]

Delete the IF.

[cangokturk]

There is no if statement in the formula. it is the name of the formatting rule.

[Bahbus]

Oh shoot. I’m dumb and didn’t even notice that was the name field.

Have you made sure to Save all the changes?

[cangokturk]

Yes, it did’t change. I deleted the “0” values from my spreadsheet and tried ISBLANK formula but did’t succeed. I tested both formula, results were given true “y/n” but it applied formatting wrong to all.

[Bahbus]

For giggles, flip the expression so the 0 is first and try that.

[Steve]

The column values appear to be grayed-out. Or do you mean the column headers?

[cangokturk]

Yes all columns values are grayed out, but for some products I have stocks and don’t want them to be grayed out.

[Steve]

As @Bahbus noted, make sure all of you changes are saved. Format rules often don’t work properly until saved in the app editor.

What other format rules do you have?

[cangokturk]

I see, and i have exprienced with my other apps before… Here is the screenshot below that shows other format rules already disabled yet it didn’t work.

[Steve]

Looks like a bug to me, then. Please email support@appsheet.com for further assistance.

[cangokturk]

Ok, merci