To Find Given ids

To find given ids from a list of ids having duplicate values
use the below formula;

"To identify Common between two columns when duplicate are there "
Column A: Find in list of ids
Column G: ids To be Find

"1) Highlight/Select all rows of the Colum in which you need to find common ids i,e column A;
2) Go to Condition format/newrules/use formula to detmine..(last one in the list)/in format value type.
3) Type in the cell =countif(select all rows of G, $A$4) remove $ behind 4
to fix we use $, in this case we no need to fix row, we can fix column.
i,e
=countif(all rows of G, $A4)
4) select color format
5) out put will highlight common ids in column A, from column G"