M
Mr. Low
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/com...dg=microsoft.public.excel.worksheet.functions
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/com...dg=microsoft.public.excel.worksheet.functions