Fonts in excel
Closed
Komal88
Posts
1
Registration date
Monday March 31, 2014
Status
Member
Last seen
March 31, 2014
-
Mar 31, 2014 at 03:54 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Mar 31, 2014 at 11:58 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Mar 31, 2014 at 11:58 AM
Related:
- Fonts in excel
- Excel date format dd.mm.yyyy - Guide
- Screenshot in excel - Guide
- Number to words in excel without vba - Guide
- Enable vba in excel - Guide
- Macros in excel download - Download - Spreadsheets
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
Mar 31, 2014 at 11:58 AM
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
