display contents of cell if adjacent cell equals

[Travis]

Is there a way to display the contents of a cell adjacent to another cell if
that cell meets a certain criteria? Example: Cell b3 equals 2 so c3
displays on the new worksheet only if it is 2. I have a parking list 1-16
but they are not aligned on the first worksheet. But the 2nd worksheet is
outlined showing what 1-16 is and the bumper number accociated with that
number.

 

[Gary''s Student]

Use Conditional formatting with a helper cell

Say Sheet1 B3 equals 2

In Sheet2 Z100 (the helper cell), enter:
=Sheet1!B2

In Sheet2, click on C3 and:
Format > Conditional Formatting > Formula Is>
=$C$3<>$Z$100
and pick the font color to match the background.

Use another helper cell if Z100 is not available.