Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I shade the active cell in excel
I have added hyperlinks to a spreadsheet, referring to data on another
worksheet in the same file. When clicking on the hyperlink, I would like the resulting text under the active cursor to be highlighted |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I shade the active cell in excel
'---------------------------------------------------------------- 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 somewhere in email address with gmail if mailing direct) "RogerK" wrote in message ... I have added hyperlinks to a spreadsheet, referring to data on another worksheet in the same file. When clicking on the hyperlink, I would like the resulting text under the active cursor to be highlighted |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
jump to active cell in other sheet . | Excel Discussion (Misc queries) | |||
how do I apply 10% gray shade to a cell in Excel? | Excel Worksheet Functions | |||
Automatically Changing Cell Reference's when Pasting in Excel | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |