» Conditional formatting depending on a cell comment using VBA in Microsoft Excel
CATEGORY - Printing in VBA
VERSION - All Microsoft Excel Versions
How can I make a conditional formatting depending on a cell commentary?
Answer:
Insert the following code into the standard module Formula for conditioned formatting: =test(Data)=True
Function Test(rng As Range) As Boolean
If rng.Comment.Text = "Test" Then
Test = True
Else
Test = False
End If
End Function
Book Store:
Recommended Books:
- Special Edition Using Microsoft Outlook 2002
- Marketing Plan: A Handbook with Marketing Plan
- The Ernst & Young Business Plan Guide
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Windows XP Annoyances
No comments have been submitted.
