Hello.
I want to format rows in a SS according to whether a cell in column "I" (and ONLY the cell in column "I") contains "CC" or not.
Column "I" either has entries that are along the lines of "CC10101" or "10101"- so either just a number or a number preceded by CC.
So I only want the row to be conditionally formatted if the cell in column "I" of that row contains CC as part of its entry.
I have tried:
=ISNUMBER(SEARCH("CC",$I2)>1
=ISNUMBER(SEARCH("CC",","&$I2&","))
and some others in a similar vein but they seem to sporadically change the formatting often even if the "I" cell does not contain a "CC" so I am clearly getting it wrong.
Any help would be much appreciated please.
I want to format rows in a SS according to whether a cell in column "I" (and ONLY the cell in column "I") contains "CC" or not.
Column "I" either has entries that are along the lines of "CC10101" or "10101"- so either just a number or a number preceded by CC.
So I only want the row to be conditionally formatted if the cell in column "I" of that row contains CC as part of its entry.
I have tried:
=ISNUMBER(SEARCH("CC",$I2)>1
=ISNUMBER(SEARCH("CC",","&$I2&","))
and some others in a similar vein but they seem to sporadically change the formatting often even if the "I" cell does not contain a "CC" so I am clearly getting it wrong.
Any help would be much appreciated please.