Allow no conditional formatting (or transparent) to be applied if the condition is not met

AnaplanIdeas

Description of the enhancement required:

Enhance conditional formatting so that it will be possible to set the fill if the condition is met but if not, the Grid Style is respected.

Currently the conditional formatting is working with a range of values where is set the fill in the left range and in the right range (with fading colors between the ranges). I want to be able to set a condition IF <Line Item> = 123abc and that the impact is that it meets the condition the fill is adjusted by a color and else it just takes the Grid Style we've defined.

 

AnaplanIdeas

Status changed to: In Review

RavinderB

Yes, this would be a valuable addition and make conditional formating more stronger for some customer use cases. We discussed this in L2 training today; especially the use of Transparency and colours.

 

Ravinder.

MattEllis

This has been in review since 2018, is there any updates?

luke_e

Great idea.

At current, any line with conditional formatting, even if not active looks like it has some form of formatting applied (even if you set a midpoint of no colour/white). There should be a way to indicate an inactive state of some sort.

bhill5

Any update on this?? thanks

kjacokes

@MattEllis , @luke_e , @bhill5 —

You should be able to do this by having a condition in the IF-THEN-ELSE formula for the numeric line item driving the conditional formatting, which if met, returns "NaN".

I usually do this with a simple: … ELSE value("") …

…which tries to convert a blank TEXT value to a NUMBER, throwing that error.

The result is the default grid formatting, i.e., transparent.

I've been using this behavior since ~2016 with good results, so all that's to say, I see this as a reliable (albeit undocumented) feature that you can count on when applying conditional formatting to classic dashboards or UX pages.

andyptsn

Alternatively, you can also assign a Read Access Driver to the Conditional Formatting line item - if the DCA line item value is false, the user cannot "see" any calculated CF value, and therefore no colour is drawn in the cell/default formatting is used instead.

You'll see similar behaviour when applying a CF line item with Summaries disabled, to another line with Summaries enabled - if no summary value exists in the CF line item, no rules are applied to the target cell.

Have used this approach regularly, especially where DCA logic for conditional inputs is already being used.