Register

Use Non-numeric Value to Drive Conditional Formatting

Use Non-numeric Value to Drive Conditional Formatting

Ability to use a non-numeric value to drive conditional formatting.

 

Ex.  I have a text formatted line item where my values are Red or Green.  For my values to set the condition, I can have text = "red" or text = "green" rather than having to create an additional line item that that resolves to a numeric value for my conditional formatting.

6 Comments
DavidSmith
Master Anaplanner/Community Boss

Love this idea, specifically for True and False values.  Having to convert efficient Boolean values into numbers for conditional formatting is not great

 

Miran
Community Manager
 
Status changed to: Your support is needed
Manuela_Apostol
Certified Master Anaplanner

It is always good to have the conditional formatting improved. Number only formatting can be sometimes not intuitive.

Rebecca
Valued Contributor
 
Status changed to: Under Investigation
NoahJ
Certified Master Anaplanner

I would love to see this. As others have said, creating a line item of IF bool THEN 1 ELSE 0 feels inefficient, when it would fit so nicely to a two color scale.

Niraj.B
Frequent Contributor

We must do this