Conditional Formatting Expression (OpenLab 2.7)

Question

I'm using the following code to report RSD values for certain peaks and compare against a theshold value. 
 
 For RTCheckArea, in the report I want the field to show in Green for Pass and Red for Fail, but I'm not able to come up with an expression which works:

ColeFunk · Answer

Go to the conditional formatting tab in the bottom left of the image you provided. You will be able to choose the formatting when a condition provided is true. In this case since you decided to say PASS or FAIL in the table, you will have to use the same calculation as before. The conditional will be at the default formatting unless the conditional is true, so I would format the text as green by default and as red in conditional formatting and provide the conditional =ABS((Compound_Amount/Compound_CalibAmount * 100) - 100) > 15.0, which is the opposite of the conditional you used to determine if it should be PASS in the if statement. If that doesn't work, you can try the if statement you had before, but just replace "PASS" with False and "FAIL" with True. The expression box in conditional formatting expects the return of True or False. Hope this helps!

Conditional Formatting Expression (OpenLab 2.7)

Top Replies