Multiple FIND functions in Conditional Formatting
 

The following formulas work when used in Conditional Formatting:

=AND(FIND(B1,"h"),LEN(G1)=2)
=AND(FIND(B1,"w"),LEN(G1)=3)
=OR(AND(EXACT(B1,"h"),LEN(G1)=3),AND(EXACT(B1,"w") ,LEN(G1)=2))

but this one does not

=OR(AND(FIND(B1,"h"),LEN(G1)=3),AND(FIND(B1,"w"),L EN(G1)=2))

The only difference is the use of FIND instead of EXACT.

RFM

Try reversing the parameters in the Find function, i.e.
=AND(FIND("h",B1),LEN(G1)=2) and make sure B1 is Text.
Ilan

Didn't help. I changes the format of the cells to Text from General and that
didn't help either.

"IlanR" wrote:

Try reversing the parameters in the Find function, i.e.
=AND(FIND("h",B1),LEN(G1)=2) and make sure B1 is Text.
Ilan