| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to set highlight for row/column header
How to set highlight of the row & column header of the active cell?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to set highlight for row/column header
Hi Jasmine, This may not be exactly what you want but have a look at this page it shows how to highlight a # of columns on the active row using a worksheet selection change macro (& will reset the cells' colour when the active cell is moved: http://www.mcgimpsey.com/excel/highl...iteRetainColor To use either of the macros shown on above page (save a copy of your file first)... Copy the suitable macro, right click on the sheet in excel that you want to apply it to, choose "view code", paste the macro, & close the active window to return to Excel. hth Rob Brockett NZ Always learning & the best way to learn is to experience... -- broro183 ------------------------------------------------------------------------ broro183's Profile: http://www.excelforum.com/member.php...o&userid=30068 View this thread: http://www.excelforum.com/showthread...hreadid=508841 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to set highlight for row/column header | Excel Discussion (Misc queries) | |||
| How to set highlight for the column&row header of the active cell | Excel Worksheet Functions | |||
| How do I setup a header in Excel that prints only on first page? | Excel Discussion (Misc queries) | |||
| Graphic in Header scaling with pages contents | Excel Discussion (Misc queries) | |||
| Default header in Excel under page set-up | Excel Discussion (Misc queries) | |||
Hybrid Mode
