Fonts in excel
Closed
Komal88
TrowaD
- Posts
- 1
- Registration date
- Monday March 31, 2014
- Status
- Member
- Last seen
- March 31, 2014
TrowaD
- Posts
- 2888
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- August 16, 2022
1 reply
TrowaD
Mar 31, 2014 at 11:58 AM
- Posts
- 2888
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- August 16, 2022
Mar 31, 2014 at 11:58 AM
Hi Komal88,
Whenever the entire comment is done in red, then the text in that cell we be purple.
Implement the following code by right-clicking the sheets tab and selecting View Code. Paste the code in the big white field.
Private Sub Worksheet_Change(ByVal Target As Range)
Best regards,
Trowa
Whenever the entire comment is done in red, then the text in that cell we be purple.
Implement the following code by right-clicking the sheets tab and selecting View Code. Paste the code in the big white field.
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Target.Comment Is Nothing Then
If Target.Comment.Shape.TextFrame.Characters.Font.ColorIndex = 3 Then Target.Font.ColorIndex = 13
End If
End Sub
Best regards,
Trowa