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

Update columns in a source
Hi, i have a source that uses a connection to Skutrak, and i selected 3 columns when i created the source, now i want to bring in a 4th column, do i have to recreate a source from scratch and then use that in a new transformation view and do all the work i did again, or can i update the source column selection, and add the…
Is it not possible to have the same link in 2 dataspaces
We have 2 dataspaces (Training and Current), the training one had a link to a list in a Model. When i tried to add a link to the same list in the Current dataspace, the link showed as ticked and i could not select it. Does this mean you cannot link to the same source in 2 different dataspaces? It shows a tick in the LINK…
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…