Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
substitute the filename in a cell reference with a string in another cell. | Excel Discussion (Misc queries) |