Quote:
Originally Posted by Colin Legg
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".