Hi Experts!
Would it be possible to used the conditional formula to highlight column M if the the denominator is NOT column D
Would it be possible to used the conditional formula to highlight column M if the the denominator is NOT column D
column D | column E | column M |
Members | Premium | Premium PMPM |
1,321 | $656,989 | =IFERROR(E6/D6,"n/a") |
1,326 | $647,586 | =IFERROR(E7/D7,"n/a") |
1,312 | $628,772 | =IFERROR(E8/D8,"n/a") |