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

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!