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.
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!
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.