With these techniques, you can make your Excel spreadsheets more visually appealing and easier to work with. You can use this same method to highlight every Nth row in Excel as well. The steps to highlight every other row are simple and involve selecting the range of cells, choosing the “Conditional Formatting” option, creating a new rule using a formula, selecting a formatting option, and applying the rule to the range. By using conditional formatting, you can quickly apply this formatting to a selected range of cells. Highlighting every other row in Excel can make it easier to read and organize large amounts of data. Note that you can replace N with any number you want to highlight rows at a different interval. Step 2: Go to the Home tab Conditional Formatting New Rule. Do not select the heading because the formula will also highlight that row. Your conditional formatting rule should now be applied to every Nth row in the selected range of cells in Excel. The steps to highlight every other row using Custom Format are as follows: Step 1: Select the data (data that we have used in example 1). For example, you can select a background color for the cells that you want to highlight. Syntax for highlight every fourth row is =MOD(ROW(),4)=0 or =MOD(ROW(),4)=1 or =MOD(ROW(),4)=2 or =MOD(ROW(),4)=3 or just =MOD(ROW(),4)Ĭlick on the “Format” button to choose the formatting that you want to apply. Syntax for highlight every third row is =MOD(ROW(),3)=0 or =MOD(ROW(),3)=1 or =MOD(ROW(),3)=2 or just =MOD(ROW(),3) You can also highlight every third of fourth row. You can create multiple rules for different conditions by repeating these steps for each new rule that you want to define. Your new conditional formatting rule should now be applied to the selected range of cells in Excel. See also How to generate random text from the list? Let’s prepare your custom conditional formatting like the ones I prepared: It can be also other kind of borders, colours, font style or pattern of cells. Of course, you can use your own conditional formatting. Isn’t it easy? Tip1 – defining own conditional formatting This time write formula: =MOD(ROW(),2)=0 and choose your second favourite colour.Įvery cells has got its own colour green or blue. Click Use a formula to determine which cells to format. Go to Ribbon > Home > Conditional formatting > New Rule. Conditional formatting started from first row. Highlighting Every Other RowĬells are coloured. ![]() You should now see every other row in the selected range highlighted with the color that you chose. In the Format Cells dialog box, select the Fill tab and choose the color that you want to use for the highlighted rows. Similarly, to highlight every 4th row, you can use the formula: MOD(ROW(),4)0, and so on. ![]() In the Format values where this formula is true box, enter the formula =MOD(ROW(),2)=1Ĭlick on the Format button to choose the formatting that you want to apply. So, if you want to highlight every 3rd row, you can use the formula: MOD(ROW(),3)0. Home > Conditional formatting > New Rule.ĭialog box appears. Select the range of cells that you want to apply the formatting to. Tip1 – defining own conditional formatting.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |