Conditional Formatting - need to add a "not equal to" to my formula

MariaR323

New Member
Joined
Sep 13, 2017
Messages
12
Maybe it's because it's soo late and I'm here working on this but I can't figure this out. Help from the masters would be appreciated.

I have a conditional formatting formula already setup and it works...

<date(2019,8,2)))
AND(($AZ10>0.249),($F10<date(2019,8,2)))
<DATE(2019,8,2)))
<date(2019,8,2)))
<date(2019,8,2))) '
<date(2019,8,2)))

a) it's looking at Col AZ to see if its more than 25% AND
b) it's looking at Col F to see if the date is before 8/2/19

But I want to add to it... I'd like to add to check if Col BC contains the word "Inactive" - if it does, I don't want it to apply conditional formatting.

I added the Orange to it but it doesn't work:

AND(($AZ10>0.249),($BC10<>"*Inactive*"),($F10<date(2019,8,2)))
<date(2019,8,2)))
<date(2019,8,2)))
</date(2019,8,2)))
</date(2019,8,2)))
</date(2019,8,2)))
</date(2019,8,2)))
</date(2019,8,2)))></date(2019,8,2)))
</date(2019,8,2)))
</date(2019,8,2)))
<DATE(2019,8,2)))
 
Last edited:

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,474
Office Version
365
Platform
Windows
Replace the orange part with
ISERR(SEARCH("inactive",$BC10))

Also when posting formulae that contain < or > you need to add spaces before & after the < & > or your formula will be destroyed.
 

MariaR323

New Member
Joined
Sep 13, 2017
Messages
12
Replace the orange part with
ISERR(SEARCH("inactive",$BC10))

Also when posting formulae that contain < or > you need to add spaces before & after the < & > or your formula will be destroyed.
Huge thanks!! This worked beautifully!

And noted on the format for posting formulas ;)
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,474
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback
 

Forum statistics

Threads
1,078,337
Messages
5,339,632
Members
399,316
Latest member
LeroyWork

Some videos you may like

This Week's Hot Topics

Top