EXCEL 利用條件格式修飾排序后數(shù)據(jù)

 

1. Sort the List by Customer Name by selecting a cell in column C  and clicking the Sort icon.(按客戶排序)
2. Select cell A1 in the Current Region and press Ctrl+Shift+*(按ctrl+shift+*選擇排序后區(qū)域)
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.(輸入公式=$C1$C2,注意絕對引用及相對引用)
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.(按確定)