display contents of cell if adjacent cell equals

T

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top