Multiple FIND functions in Conditional Formatting

[RocketFuMaster]

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"),LEN(G1)=2))

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

RFM

 

[IlanR]

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

 

[RocketFuMaster]

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