» Conditional formatting depending on a cell comment using VBA in Microsoft Excel
CATEGORY - Printing in VBA
VERSION - All Microsoft Excel Versions
Question: 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:
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- How to Pay Zero Taxes (Annual)
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- Business Analysis with Microsoft Excel (2nd Edition)
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Mortgages For Dummies®
No comments have been submitted.
