Coloring of values that are out of limits

Question

Hello everyone, 
 In reporting, how do I get it to color the value red if match factor is below 950 and resolution is below 1,2?

martin.adams · Answer

Hello, 
 
 You would need to use conditional formatting on the table column to change the background or font color. In the case of the spectral match there is another field called Compound_SpectraConfirmResult which returns a 1 for peaks the meet the method match factor limit and 2 for peaks that do not. To test the resolution, you would just add the numeric values for the limit or use a report parameter if you change the limit often. Y ou can search the help for conditional formatting to get more information. 
 
 Marty Adams

Coloring of values that are out of limits

Top Replies