copying conditional formatting

[lezawang]

Hi
I have a table and I created a data validation list so the user can select name from the list and if the name is matching what is in the table then that name will be highlighted yellow. So the conditional formatting formula is =A1=$H$6.

I wanted to copy the cell which has "Linda2", which is data validation list to somewhere else. I copied but the conditional formatting did not get copied? I tried to use FormatPainter but did not help.
Is it possible to copy conditional formatting as well if I copy the cell which has Linda2 in this example?

Thank you so much.
+++++

enter name

linda2

<tbody>
</tbody><colgroup><col><col></colgroup>

name	jan	feb	mar
mary1	601	242	700
david1	342	443	329
sarah1	634	592	345
adam1	948	484	857
mike1	771	781	552
john1	636	500	732

<tbody>
</tbody><colgroup><col span="4"></colgroup>