![]() Thus, the EVEN rows will be Highlighted.It will only Highlight the rows where the row number is odd. From the box, select Use a formula to determine which cells to format.As a result, a dialog box will be on the screen.Then, open the Home tab > Go to Conditional Formatting > now select New Rule.To begin with, select the cell range that you want to Highlight and want to select.In this instance, we will highlight only the odd rows using the Conditional Formatting option. We will use the ISODDand ISEVENfunctions to separately select the odd and even rows. In this method, we will highlight alternate rows using the Conditional Formatting option. Read More: Excel Alternating Row Color with Conditional Formatting Now, select the first Highlighted row then hold the CTRL key and select the rest of Highlighted rows.Consequently, the MOD(ROW(),2)=0 functions will Highlight every 2nd row starting from the first.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |