C.F.

  • Thread starter Thread starter Herman
  • Start date Start date
H

Herman

can C.F. be set to trigger using only 1 C.F. with 2
conditions ie
I would like a cell to change background when the following
condition appears "P1O" or "GO1" the trigger being alpha
"O" note "P,G,1" are not necessarily the same they can be
any alpha/numeric.I hope to be able to do this using only 1
of the 3 C.F.'s as I need them also,
 
If you mean the test is whether the text contains an upper case O,

=ISNUMBER(FIND("O",A1))

Use SEARCH instead of FIND if it isn't supposed to be case-sensitive.
 
Back
Top