Share
Report 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 (
Answers (
