Conditional Formating

[anneb_87]

Hi Experts!

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")

 

[arthurbr]

Unchecked, try following CF=not(isnumber(search("/D",get.cell(6,$M2))))
You'll have to save the file as .xlsm

 

[anneb_87]

Is there a way that the file should not be saved in macro format? The client does not what it ?

 

[Fluff]

If you have the Formulatext function, try
=NOT(SEARCH("/D",FORMULATEXT(M6)))

Please update you account details to show which version of Excel you are using, as it affects which functions you have.

 

[anneb_87]

Thanks!! Formulatext works fine.??

 

[Fluff]

You're welcome & thanks for the feedback.

Please don't forget to update your account details, to show which version of Excel you are using.