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...