Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cursor highlighting
How do I make cursor highlighted border of cells bold?
|
#2
|
|||
|
|||
An example to work from:
http://www.xl-expert.com/html_pages/condFormatting.html -- Rob van Gelder - http://www.vangelder.co.nz/excel "mukbibliophile" wrote in message ... How do I make cursor highlighted border of cells bold? |
#3
|
|||
|
|||
I may be mis-reading what you want to do, but give this a try
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Cells.FormatConditions.Delete With Target .FormatConditions.Add Type:=xlExpression, Formula1:="TRUE" With .FormatConditions(1) With .Borders(xlTop) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = 5 End With With .Borders(xlBottom) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = 5 End With End With .FormatConditions(1).Interior.ColorIndex = 20 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 RP (remove nothere from the email address if mailing direct) "mukbibliophile" wrote in message ... How do I make cursor highlighted border of cells bold? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|