![]() ![]() 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. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |