Can you copy Col A from Sheet1 to the sheet which you want to higlight?

If you can then assuming you copied it to Col Z do the following;
Select the range you want to highlight (assuming it starts at A1, if not
then change A1 below to the first cell)
Choose Conditional Formatting
Chooe Formula IS
Type the formula
=NOT(ISNA(VLOOKUP(A1,$Z:$Z,1,FALSE)))
Choose the format you want


" wrote:

Worksheet 1 consists of a single column containing the first 1000
prime numbers. Worksheet 2 consists of multiple columns of numbers.
Is there a way to highlight with a chosen fill color all cells in
worksheet 2 containing prime numbers from worksheet 1? Thanks.