View Single Post
 
Old 06-05-2012, 09:11 AM
tinfanide tinfanide is offline Windows 7 64bit Office 2010 32bit
Expert
 
Join Date: Aug 2011
Posts: 312
tinfanide is on a distinguished road
Default

Quote:
Originally Posted by Colin Legg View Post
One way - the conditional formatting formula you could use to do this would be:

case insensitive
=COUNT(SEARCH({"teacher","tutor"},A1))=0

case sensitive
=COUNT(FIND({"Teacher","Tutor"},A1))=0
Thank you for your reply.
Please take a look at the attached file alongside with the questions below:
test.xlsx

Ques 1:
But in Excel 2010, it does not work in the conditional formatting formula as it returns something like "cannot use array in conditional formatting formula".

Ques 2:
In Column B, I want to know why Cell B2 returns a value error but B4 doesn't? Indeed, I think B2 shouldn't have returned a value error.

And
I have come up with a solution in Column E to avoid using array in the formula with the use of "AND".
Reply With Quote