Disable all cell formatting

[#1]

I'm using cell formatting to show erroneous data in a chart. This is done by adjusting background colour and text colour in every expression; for example like this for background colour:

=if( (TaskGoLiveDate < TaskCreatedDate) ,red(),)

Now I'd like to add a toggle button to show/disable this formatting. The only way I can think of is to create a variable like vShowFormatting and then add an IF-statement to only show the formatting if the variable is set to a certain value. I can then create a button that toggles this value.

However, I have formatting for a lot of different expressions. So it would take a lot of time to edit each expression one by one. Is there any other way to achieve cell formatting on/off?

[Anonymous · Accepted solution]

Gustav

Using a variable like you are planning sounds sensible, and yup editing loads of expressions can be right pain.  But can be made less painful by, in the QV Desktop :

• Settings
• Expression Overview

This shows all expressions in one go and allows you to do Find/Replace across all of them.

I would strongly suggest you take a backup copy of qvw first, as using this, especially for the first time, it is possible to destroy things.

Best regards,     Bill

[#3]

Thanks Bill, I'll just have to do it that way then. Thanks for the tip on the expression editor!