» Drawing Lines Between Sorted Groups
CATEGORY - Excel Sorting
VERSION - All Microsoft Excel Versions
1. Sort the List by Customer Name by selecting a cell in column C (see screenshot) and clicking the Sort icon.
2. Select cell A1 in the Current Region and press Ctrl+Shift+* (in Excel 2003, press this or Ctrl+A).
3. From the Format menu, select Conditional Formatting.
4. In Condition 1, select Formula Is.
5. In the Formula box, enter the formula =$C1$C2. Be sure to enter the formula with absolute reference for the column and relative reference for the row.
6. In the Conditional Formatting dialog box, click the Format button, select the Border tab, in Border section click Underline and then choose a color.
7. Click OK twice.
Book Store:
Recommended Books:
- East of Eden (Oprah's Book Club)
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- The New Financial Order: Risk in the Twenty-First Century
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- Financial Peace: Revisited
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
No comments have been submitted.
