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

Hi Team , I am unable to login to the Anaplan portal using my credential.
Can someone help me i am unable to login anaplan portal using my credentials
Finding History for List Item Creation and changes
Dear Hive Mind, Do we have a way to get the history of a particular List Item, from its creation into a model up until its removal ? I am trying to chase when / how an item has been added into a model and how / when it would have been deleted and then recreated with the same code. Is there a pattern (manual or API) to get…
Action fails via cloudworks but works manually
I have an action in a process which is getting failed since 2 days when run via CloudWorks with below error . No issues when run manually . Same error occurs when run manually but as a warning "Import complete but with failures" This action is running since almost a year without any issue . No change has been made to…