| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Is it possible to high light a row of cells
I have columns from A1 to A300 TO CP1 TO CP300 if I click on a particulr cell
on any row is it possible to high light that whole row if there is a way please tell me how!!! |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Is it possible to high light a row of cells
On dec. 10, 04:23, Mike wrote:
I have columns from A1 to A300 TO CP1 TO CP300 if I click on a particulr cell on any row is it possible to high light that whole row if there is a way please tell me how!!! You need an event sub for that like this one: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Not Intersect(Target, Range("A1:F10")) Is Nothing Then Range("A1:F10").Interior.ColorIndex = xlNone Range("A" & Target.Row & ":F" & Target.Row).Interior.ColorIndex = 6 End If End Sub Post if you need help to install it! Regards, Stefi |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Is it possible to high light a row of cells
You may want to take a look at Chip Pearson's rowliner utility.
http://www.cpearson.com/excel/RowLiner.htm Mike wrote: I have columns from A1 to A300 TO CP1 TO CP300 if I click on a particulr cell on any row is it possible to high light that whole row if there is a way please tell me how!!! -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| high light the selected cell | New Users to Excel | |||
| Conditional Formating for dates beyond 30, 60, 90 to be high light | Excel Worksheet Functions | |||
| How to replace the background color of all cells from light green to light blue? | Excel Discussion (Misc queries) | |||
| Excel should high-light Rows & Columns when cell selected. | Setting up and Configuration of Excel | |||
| high light row your working in | Excel Discussion (Misc queries) | |||
Linear Mode
