In the Details worksheet of the Conditional workbook: - In the cell range C3:J26, apply conditional formatting so that cells that contain values over 200,000 display with green fill and text and values under 10,000display with a red border.- Display the Three Arrows (Colored) icon set for all the values in the Extended Price column. Then show blue data bars for the same values. Finally, in the same column, fill all cells containing values over $100 with yellow. Configure Excel to first process the rule that makes the cells fill with yellow, and not toprocess any more rules for cells that meet the first condition.
đang được dịch, vui lòng đợi..
