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.
--
Gary''s Student - gsnu200790


"Travis" wrote:

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.