conditional formatting based on text value

MadhabikaM

Hi All,

I have a text formatted line item which gives me the text message "Error" or "No error" based on condition satisfied.

I want to color all the row having message "Error" as light yellow and "No Error" as light green.

Regards

Madhu

Accepted answers

All comments

anirudh

Hi Madhabika,

Create a line item called Error Color with this formula

IF Error text = "Error" THEN -5 ELSE IF Error text = "No Error" THEN 5 ELSE 0

Then in the conditional formatting options, use these settings:

Hope this helps!

DavidSmith

It would be better from a memory perspective to use a formatted list for Error and Non Error. List formatted line item use half as much space and a lot less memory. If you set the code of the list to be the number you want to use for the conditional formatting, you could use a code(line item)) to return the number
David

kavinkumar

@MadhabikaM

As you mentioned Yellow and Green Combination, go with 2Color scale format (Green - Yellow). We don't have Yellow White Green combo in 3color scale.

Regards,

Kavin.

Quick Links

Can you help?

Unanswered questions

ADO data types - need definitions/explanations
what are these? when do you use them? why one over another? thanks Data types string long float bool date datetime datetimetz
API certificats renewal
Hello Anaplan Community, We are currently facing an issue related to certificate validation and would appreciate your help or guidance. We are getting the following error: Unable to build certificate chain for Cert [subject DN = EMAILADDRESS=********, CN=service account email address, cert serial number = XXXXX; issuer DN…
Time hierarchy filter new ux when brought forward option is turned on?
Hello, Does anyone know any workaround or a solution to be able to enable the hierarchy filter in new ux when the brought forward option is selected in backend? I do not see the above hierarchy filter option if I enable the brought forward for a line item-