Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mr. Low
 
Posts: n/a
Default Highlighted Reference Cell for a Working Cell

Dear Sir,

Further to my suggestion entitled " Highlighted Rows and Column of a Working
Cell" . I would like to put forward another alternative suggestion just come
into my mind:

Let consider the folowing worksheet:

A B C D E F G
1 K512 120
2 K524 260
3 B626 210
4 C939 348
5 C211 Position 1
6 E145 Position 2
7 K129 Position 3
8
9
10

At position 1, the highlighted reference cell will be at A5 only i.e. Cell
A5 may be highlighted in pink while working cell may be in light green. When
the cell is moved to position 2, the pink reference cell will move along to
cell A6. The reference cell can be set in accordance to the need of the
reading of the corresponding cell content before data is key into the working
cell. It will move along with the working cell so that the content of the
reference cell can be read easily and error free.

I hope my suggestion is helpful for you.

Kind Regards

Low Seng Kuang


--
A36B58K641

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions
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
Maintaining cell reference after sorting GRITS Excel Discussion (Misc queries) 2 April 30th 23 07:42 PM
Compiling macro based on cell values simonsmith Excel Discussion (Misc queries) 1 May 16th 06 08:31 PM
Help with this conditional IF statement C-Dawg Excel Discussion (Misc queries) 3 May 15th 06 06:01 PM
Urgent date/scheduling calc needed jct Excel Worksheet Functions 3 February 24th 06 01:36 AM
substitute the filename in a cell reference with a string in another cell. flummi Excel Discussion (Misc queries) 11 February 22nd 06 01:14 PM


All times are GMT +1. The time now is 08:14 AM.

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

About Us

"It's about Microsoft Excel"