![]()
If you use it on very large datasets, it may lead to a slow workbook. This method would not impact any formatting/highlighting you have done manually to the cells.Since these are two different formulas, you can specify two different colors. #EXCEL FOR MAC HIGHLIGHT ROW CONDITIONAL FORMATTING DOWNLOAD#In the download file provided with this tutorial, I have created two tabs, one each for single color and dual color highlighting. If you want to highlight the active row and column in different colors, use the below formulas: Note that in the steps listed above, the active row and column would get highlighted with the same color. #EXCEL FOR MAC HIGHLIGHT ROW CONDITIONAL FORMATTING CODE#Since the workbook has VBA code in it, save it with a.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |