Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I highlight one cell when clicking on another cell?
I have a spreadsheet which is rather large and has to be viewed at a rather
small size. I am restricted in that I cannot Hide, Split or Freeze anything on the worksheet (blame internal politics at the company I work for for that decision) Is there a way that when I click on a cell (say K1) so that the data in another cell (say A1) can be displayed with alternate formatting features (eg bold or a different colour font/cell color) or that a pop-up window can appear with the data from another cell. The 'other' cell I want to display contains only a date and does not get updated for the life of the spreadsheet. The cell to be displayed is always relative to the row in which the cell I am selecting eg. A1 K1 A2 K2 A3 K3 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I highlight one cell when clicking on another cell?
Well, technically speaking you can do what you want by adding VBA code to the
sheet's Worksheet_SelectionChange event. However, if you're not allowed to Freeze Panes, there's no way you'll be allowed to add macro code. Can't you make a copy of the sheet and Freeze column A on the copy? "Oldersox" wrote: I have a spreadsheet which is rather large and has to be viewed at a rather small size. I am restricted in that I cannot Hide, Split or Freeze anything on the worksheet (blame internal politics at the company I work for for that decision) Is there a way that when I click on a cell (say K1) so that the data in another cell (say A1) can be displayed with alternate formatting features (eg bold or a different colour font/cell color) or that a pop-up window can appear with the data from another cell. The 'other' cell I want to display contains only a date and does not get updated for the life of the spreadsheet. The cell to be displayed is always relative to the row in which the cell I am selecting eg. A1 K1 A2 K2 A3 K3 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I edit a cell in Excel without clicking on the cell first? | Excel Worksheet Functions | |||
Can I toggle the value of a cell by clicking directly on the cell? | Excel Discussion (Misc queries) | |||
How to highlight an Excel row by clicking on a cell | Excel Worksheet Functions | |||
Clicking Cell Link Changes Cell on Another Sheet | Excel Discussion (Misc queries) | |||
Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) |