Conditional formatting problem

[ddub25]

=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?

 

[Eric W]

Maybe:

=(COUNTIF(CriteriaMet,"*"&CI103&"*")>0)*(CI103<>"")

 

[Tetra201]

Try this:

=AND(COUNTIF(CriteriaMet,"*"&CI103&"*")>0,CI103<>"")

 

[ddub25]

Thanks for you help, problem solved

 

[Tetra201]

You are welcome.