Conditional Formating

anneb_87

Board Regular
Joined
Jun 13, 2018
Messages
52
Hi Experts!

Would it be possible to used the conditional formula to highlight column M if the the denominator is NOT column D

column Dcolumn Ecolumn M
MembersPremiumPremium 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")
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

arthurbr

Well-known Member
Joined
Dec 8, 2006
Messages
2,001
Office Version
2010
Unchecked, try following CF=not(isnumber(search("/D",get.cell(6,$M2))))
You'll have to save the file as .xlsm
 

anneb_87

Board Regular
Joined
Jun 13, 2018
Messages
52
Is there a way that the file should not be saved in macro format? The client does not what it 😰
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
41,201
Office Version
365
Platform
Windows
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.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
41,201
Office Version
365
Platform
Windows
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. ;)
 

Watch MrExcel Video

Forum statistics

Threads
1,100,037
Messages
5,472,112
Members
406,804
Latest member
xbinsx

This Week's Hot Topics

Top