Use Conditional formatting with a Named range.

Say Sheet1 has the numbers in column A. Click on column A and:

Insert Name Define and use the Name colA.

Then click on a typical cell in Sheet2 (say B1) and:

Format Conditional Formatting... FormulaIs

=COUNTIF(colA,B1)0 and pick the color.

NOTE that without the Defined Name, conditional formatting will not work
across sheets.
--
Gary''s Student - gsnu2007L


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