Visual Formatting not giving proper result

[manish.agrawal446@gmail.com]

Hi,

I have made an active cell at G2. And from A24:V75 I have selected the conditional formatting =AND($G$2<>"",COUNTIF(A24,"*"&$G$2&"*")>0)

When any text is inputted in active cell, wrong values are getting highlighed


https://rapidshare.com/files/2389528324/Issues_for_testing__July__12_.xlsx

 

[manish.agrawal446@gmail.com]

I got my mistake.. Able to resolve