Need Help with highlighting found date.

[flipit]

Hello great minds, Im a newbie and need help. Using excel 2007.

I have phone numbers in column A that im trying to find in column B using this formula:
=IF(COUNTIF($B$2:$B$663,A2),A2,0)

is there a way I can tell excel to show me the found data highlighted in column B?

thanks in advance.

 

[MUKESHY12390]

Hello great minds, Im a newbie and need help. Using excel 2007.

I have phone numbers in column A that im trying to find in column B using this formula:
=IF(COUNTIF($B$2:$B$663,A2),A2,0)

is there a way I can tell excel to show me the found data highlighted in column B?

thanks in advance.

Hey.. I think you can use conditional Formatting Rules Manager


and Put the Following code..!

=$A$1=$B1:$B1048574


Above Formula has two part
1)$A$1 ---containing value I have to find out in $B1:$B1048574
2)$B1:$B1048574 -----------Containing whole data..!

And set the Colour Format.
Hope this will help you..!!


Thanks...!!