| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
set the background color of the current cell(active cell)
how to set the background color the row of the current cell(active cell)
each time I click the cells. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
set the background color of the current cell(active cell)
Hi,
Right click the sheet tab, view code and paste this in. Public OldRange As Range Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not OldRange Is Nothing Then OldRange.Interior.ColorIndex = xlNone End If Target.Interior.ColorIndex = 36 Set OldRange = Target End Sub Mike "kang" wrote: how to set the background color the row of the current cell(active cell) each time I click the cells. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
set the background color of the current cell(active cell)
Download Chip Pearson's RowLiner add-in to gain this functionality.
http://www.cpearson.com/excel/RowLiner.htm Gord Dibben MS Excel MVP On Tue, 31 Jul 2007 14:12:18 +0900, kang wrote: how to set the background color the row of the current cell(active cell) each time I click the cells. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I- IF the cell background is RED in color then contain 1 | Excel Worksheet Functions | |||
| How to add todays date (static) to the current active cell using m | Excel Discussion (Misc queries) | |||
| Populate current active cell - Help Please!! | Excel Worksheet Functions | |||
| Identify current active cell | Excel Worksheet Functions | |||
| Default Border, Font Color, and Cell Background Color | Excel Discussion (Misc queries) | |||
Linear Mode
