Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi all
When I have lists in excel numbers down the left and numbers across the top, is it possible for the active cell i.e say 5 down and 4 across to be highlighted when that cell is selected? If so how? Many thanks |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
'----------------------------------------------------------------
Private Sub Worksheet_SelectionChange(ByVal Target As Range) '---------------------------------------------------------------- Cells.FormatConditions.Delete With Target .FormatConditions.Delete .FormatConditions.Add Type:=xlExpression, Formula1:="TRUE" .FormatConditions(1).Interior.ColorIndex = 36 End With End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "skint" wrote in message ups.com... Hi all When I have lists in excel numbers down the left and numbers across the top, is it possible for the active cell i.e say 5 down and 4 across to be highlighted when that cell is selected? If so how? Many thanks |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
skint, you may also want to look at Chip's row liner addin here
http://www.cpearson.com/excel/RowLiner.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "skint" wrote in message ups.com... Hi all When I have lists in excel numbers down the left and numbers across the top, is it possible for the active cell i.e say 5 down and 4 across to be highlighted when that cell is selected? If so how? Many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Active Cell will not scroll to next cell | Excel Discussion (Misc queries) | |||
Populate current active cell - Help Please!! | Excel Worksheet Functions | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
How do I have an active cell highlight automatically | Excel Discussion (Misc queries) | |||
Highlight Active Cell...With a Diffrence | Excel Discussion (Misc queries) |