Coloring of values that are out of limits

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?

Parents
  • 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. You can search the help for conditional formatting to get more information. 

    Marty Adams

Reply
  • 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. You can search the help for conditional formatting to get more information. 

    Marty Adams

Children
No Data
Was this helpful?