| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
active cell bold
Im trying to make the active cell either bolded or highlighted. Is that
possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
active cell bold
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) With Cells.Font .FontStyle = "Regular" End With With ActiveCell.Font .FontStyle = "Bold" End With End Sub Vaya con Dios, Chuck, CABGx3 "Dtech" wrote: Im trying to make the active cell either bolded or highlighted. Is that possible? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
active cell bold
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
active cell bold
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? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
active cell bold
Thats frickin awesome. Thanks a bunch.
"Peo Sjoblom" wrote: 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? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
active cell bold
Just as long as you realize that this wipes out color formatting from every cell
other than the active cell with no going back. Gord Dibben MS Excel MVP On Thu, 17 May 2007 13:00:01 -0700, Dtech wrote: Thats frickin awesome. Thanks a bunch. "Peo Sjoblom" wrote: 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? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
active cell bold
Right on Gord............that's why I stuck with just the "bolding" part in
my response. Vaya con Dios, Chuck, CABGx3 "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Just as long as you realize that this wipes out color formatting from every cell other than the active cell with no going back. Gord Dibben MS Excel MVP On Thu, 17 May 2007 13:00:01 -0700, Dtech wrote: Thats frickin awesome. Thanks a bunch. "Peo Sjoblom" wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUM if cell is Bold | Excel Discussion (Misc queries) | |||
| SUM if cell is Bold | Excel Worksheet Functions | |||
| Extract bold letters in a cell | Excel Worksheet Functions | |||
| Join bold and non-bold text in one cell | Excel Discussion (Misc queries) | |||
| How can i test a cell for bold style in a cell (Excel 2003)? | Excel Worksheet Functions | |||
Linear Mode
