Conditional format and Or & FIND

[athegn]

In column B I could have blank, text or text containing the word "track" or "Track". In column C I could have Blank, "yes" or "Yes" or "no" or "No"

Only if B text contains "track" or "Track" and/or C contains "yes" or "Yes" I want to conditionally format B.

This does not work:-

=OR(FIND("track",B1,1),FIND("Track",B1,1),C1="yes",C1="Yes")

Can anyone please advise?

[DonkeyOte]

FIND is Case Sensitive (A <> a) whereas SEARCH is not (A = a)

Conditional Formula:

=AND(ISNUMBER(SEARCH("track",B1)),ISNUMBER(SEARCH("yes",C1)))

[athegn]

Thank you for your formula:_

=AND(ISNUMBER(SEARCH("track",B1)),ISNUMBER(SEARCH("yes",C1))

However the formula only works where there is "track" text in B and "yes" in C.

It does not work where there is only "track" text in B or only "yes" in C.

Any further advice please?

[deadlyduck]

If you change DonkeyOte's formula to the following it should conditionally format the cells if either B1 contains 'track' or C1 contains 'yes' or they both contain the relevant text:

Please Login or Register  to view this content.

[athegn]

Thank you both for your help.

[zbor]

Please make thread as [solved]