You can alternate colors of lines in Excel 2007 to work efficiently, avoid confusion between rows, columns, especially create professional spreadsheet files. How to alternate coloring between lines in Excel 2007 will be Taimienphi.vn to the instructions in the following article.
Step 2: In the Conditional Formatting Rules Manager window, choose Edit Rule.
Step 3: In the New Formatting Rule box that appears, click Format.
Step 4: In the Format Cells window, click Fill, select the color you want to change again, and then click OK.
Step 5: Keep clicking OK to confirm.
Step 6: Click OK to complete your changes.
As shown below, I have successfully changed from green to orange.
3. Return the alternately colored lines back to their default form
After solving the job, if you want to bring your Excel file back to the way it was, do the following:
Step 1: Similar to step 1 of the Recoloring Guide section painted for the alternating lines above.
Step 2: In the Conditional Formatting Rules Manager window, select Delete Rule, and then click OK
You will see that your Excel file has been returned to its original format.
So Software has shown you how to alternately color lines in Excel 2007 as well as how to change the selected color back and how to return the filled lines to their default form. The alternating coloring of lines will help you have a visual view, easily follow your Excel data table, avoid unnecessary errors. Wish you are advantageous in your work with this Excel trick of alternating coloring lines.
How to number pages in Excel is also very important in case your document has too many pages, if you do not know how to do it, you can follow the tutorial