![]() When you enter "1" in cell A1, you expect the color of cell B1 to change to red. This code automatically applies the conditional formatting to cell B1 when you enter "1" in cell A1. FormatConditions(1).Interior.ColorIndex = 46 ![]() FormatConditions.Add Type:=xlExpression, _ With ThisWorkbook.Worksheets(1).Range("B1") ThisWorkbook.Worksheets(1).Range("A1").Select When you apply the conditional formatting, you notice that the conditional formatting is not set correctly.įor example, you experience this problem when you use a program that includes VBA code in an Excel worksheet that is similar to the following code: Sub Example() You apply the conditional formatting to a cell other than the selected cell.You use relative cell references in the VBA conditional formatting program.You use Microsoft Visual Basic for Applications (VBA) to create a formula-based conditional formatting program.You select a cell in a worksheet in Microsoft Excel 2000 or in a later version of Excel.For more information about this change, read this blog post. Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |