=IF(COUNTIF(CriteriaMet,"*"&CI103&"*")>0,TRUE,FALSE)
I'm trying to use this for conditional formatting. If the text string in CI103 can be found in the 'CriteriaMet' range, then apply formatting. I have tested it, and it correctly applies the formatting only when the text is present, but it also applies formatting when CI103 is empty.
I've tried without the 0:
=IF(COUNTIF(CriteriaMet,"*"&CI103&"*"),TRUE,FALSE)
but get the same result.
Can anyone help?
I'm trying to use this for conditional formatting. If the text string in CI103 can be found in the 'CriteriaMet' range, then apply formatting. I have tested it, and it correctly applies the formatting only when the text is present, but it also applies formatting when CI103 is empty.
I've tried without the 0:
=IF(COUNTIF(CriteriaMet,"*"&CI103&"*"),TRUE,FALSE)
but get the same result.
Can anyone help?