View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default active cell bold

They are not formulas, formulas cannot do this. You would need event macros
Right click the sheet tab where you want this to happen and select view
code. then paste in the code. Press Alt + q and save the workbook


--
Regards,

Peo Sjoblom


"Dtech" wrote in message
...
Can I have that a little slower so my small brain can take it in? Are
these
formulas added to the entire selection? Sorry.


"FSt1" wrote:

hi
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Cells.Interior.ColorIndex = xlNone
With Cells.Font
.FontStyle = "regular"
End With
ActiveCell.Interior.ColorIndex = 6 'yellow
With ActiveCell.Font
.FontStyle = "bold"
End With
End Sub

regards
FSt1

"Dtech" wrote:

Im trying to make the active cell either bolded or highlighted. Is that
possible?