If you need to apply this to columns rather than rows, use this formula instead: =MOD(COLUMN( ),2)Īlthough this method applies the formatting specified to every second row or column quickly and easily, it is not dynamic. You also should have some patience left for the rest of the day. The format you specified should be applied to every second row in the range A1:H100. Conditional Formatting dialog containing the MOD formula to specify a format to every second row in a rangeĬlick the Format button and choose the format you want to apply to every second row. ![]() ![]() In the Formula box, type the following formula, as shown in the figure: =MOD(ROW( ),2)įigure. From the drop-down that currently says Cell Value Is, select Formula Is. Now, select Format » Conditional Formatting. Select this range of cells, starting with A1, thus ensuring that A1 is the active cell in the selection. We'll assume your data occupies the range A1:H100. Fortunately, conditional formatting can reduce the amount of patience required and enhance your professional image. You can apply this formatting manually, but as you can imagine, or might have experienced, it's a rather time-consuming task that requires constant updating as you add and remove data from the table. Alternating colors or shading looks professional and can make data easier to read.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |