Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Management Reporter

Management Reporter

(0) Share

Report

Posted on by Community Member

Does anyone know how to create a parameter or formula to where data is highlighted or formatted based on the results of the formula. For instance I have several columns and I need to display or highlight data in those columns based on parameters. sample I have columns %slip, Job#, %Delta, $Slip, $Delta If %slip is > -1.49% and $slip is > -$19,999, JOB# highlights cell yellow OR If %Delta is > -1.49% and $Delta is > -$19,999, JOB# highlights cell yellow And, in the columns $slip and $Delta Any dollar sum > -49,999 highlights the cell orange but only if the % slip or % Delta is > -0.99% meaning -1% or more

*This post is locked for comments

All responses (1)

Answers (0)

EDJJR on at

Like (0)

Report

RE: Management Reporter

Good Afternoon,

Unfortunately, there is no a way to highlight a line, cell or column based on the results of the formula.

You are able to manually highlight the entire row or column.

Thank you