Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
To anyone who can help,
I am trying to change all the text of a row to red and bold when that row is selected and then change it back to black and unbold when it is deselected. I have achieved the first part of my task with the following code: Private Sub Worksheet_SelectionChange(ByVal Target As Range) If ActiveCell.Row = 4 Then ActiveCell.EntireRow.Font.ColorIndex = 3 ActiveCell.EntireRow.Font.Bold = True End If If ActiveCell.Row = 5 Then ActiveCell.EntireRow.Font.ColorIndex = 3 ActiveCell.EntireRow.Font.Bold = True End If End Sub Can someone please help with the else statement that I would need to add so that when I change from say, row 4 to 5, the text in row 4 is returned to black and unbold while the text in row 5 is changed to red and bold? Any help will be much appreciated |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change selected cell shading colour | Excel Discussion (Misc queries) | |||
how do I change the colour of selected auto filter tabs | Excel Worksheet Functions | |||
selected cells doesnot change colour | New Users to Excel | |||
change highlight colour of selected cells | Excel Discussion (Misc queries) | |||
how to colour the entire row with the selected word | Excel Discussion (Misc queries) |