4/10/2023 0 Comments Use conditional formulas for mac![]() Unfortunately, it doesn't work exactly right in either Windows or Mac Excel. Selection.FormatConditions(1).StopIfTrue = False Selection.FormatConditions().SetFirstPriority I recorded the actions required in Excel 2016 for Windows and got this code: As you observed, the Mac version does respond correctly to Conditional Formatting generated in Excel for Windows.Įxcel for Mac also honors Visual Basic for Applications (VBA) code regardless of whether it is generated on Excel for Mac or Windows. ![]() ![]() Excel for Mac does not have the interface for number formatting in the Conditional Format dialog. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |