FIND LETTER IN CELL (cond. form mult entries not wrking)
in Conditional Format, trying to shorten many examples of:
=OR(LEFT(CM9,1)="h",RIGHT(CM9,1)="h")
to something like:
=OR(FIND(CM9,"H"),FIND(CM9,"X"))
but cannot get multiple items to be valid in a conditional format. is there
another way or something doing wrong? thanks.
|