Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 43
Default display contents of cell if adjacent cell equals

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.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,058
Default display contents of cell if adjacent cell equals

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Very Basic Problem - Merged Cell Equals Contents of a Single Cell jollynicechap Excel Worksheet Functions 3 December 29th 06 09:16 PM
display text in one cell as a number in an adjacent cell in excel Denno New Users to Excel 1 November 16th 06 06:13 PM
Delete cell contents with input to adjacent cell Ashley Frank Excel Discussion (Misc queries) 1 October 5th 05 04:28 PM
Contents of adjacent cell from a function Nick Excel Worksheet Functions 5 July 8th 05 04:28 PM
have cell display the word balance when a equals the same amount a jenniss Excel Discussion (Misc queries) 8 February 6th 05 06:06 PM


All times are GMT +1. The time now is 01:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"