Conditional formatting to mark cells with on text strnig but lacking another text string

Hello,

I need conditional formatting to find references to restaurants in a certain column on my spreadsheet. The data sometmies has "restaurant" but more often has "rest," so "rest" is the text string in the formatting formula. However, I need to exclude results with "no rest" which (obviously) indicates "no restaurant."

Because I (and the other users of this spreadsheet) can't make anything simple, there are actually two formulas I need to update.


One formula is contingent on both the business type (column T) and the last time the business was inspected (column Q):
=AND(SEARCH("rest",T1),(Q1<TODAY()-550)+(Q1="00/00/00"))

(00/00/00 indicates that the business has never been inspected)


The other formula just checks for any of several different business type indicators:
=OR(ISNUMBER(SEARCH("rest",T1)),ISNUMBER(SEARCH("$",T1)),ISNUMBER(SEARCH("otel",T1)),ISNUMBER(SEARCH("body shop",T1)))


How can I exclude cells including "no rest" from these results? This is in Excel 2010.

Thanks in advance,
Kelsey

Works like a charm! Thanks for your help!