Display CF Icons (based on date) Except when Status = these text values

[mwyller]

I'm trying to use Icon Sets to indicate the 'Age' of the last update made to the file but only want to display this 'Aging' icon when the Status IS NOT certain text values.

Here's some sample data:
a b c
1 Date Updated Status Icon
2 1/25/2018 √
3 1/24/2018 Resolved
4 1/23/2018 WIP √
5 1/24/2018 Complete
6 1/20/2018 Sometext !
7 1/5/2018 X
8 1/5/2018 Resolved

The Conditional Formatting for the Icon is setup uses "Today()" expressions:
=TODAY()-$B2>=4 Updated 4 or more days ago:
=TODAY()-$B2=3 Updated 3 days ago
=AND(TODAY()-$B2>=0, TODAY()-$B2<=2) Updated in last 2 days

√ Updated in the last 2 days
! Updated 3 days ago
X Updated 4 or more days ago

I have a range of cells (NoShow) containing status text values that if they appear in my data, DO NOT display any icon.
I can test my data for this 'exception test' a couple of ways:
=SUMPRODUCT(--ISNUMBER(SEARCH(NoShow,$2)))>0
or another way...
=FIND("Moved",$B2)

I just don't know how to combine these tests to get the result I want.
Can someone give me a hint please?

 

[DRSteele]

I'm not quite sure this is the solution, but try it and let us know. Move your SUMPRODUCT or FIND CndFrmt rule to the top of the rules list and then select Stop if True for it.

 

[mwyller]

Thanks for the reply - I tried this without success.
If I find a solution, I'll be sure to share it here.

Thanks again!
Mike