Page 26 - TP_Prime_V2.2_Class7
P. 26
Step 3: Select the desired conditional formatting. In this case, we have selected the
Orange Data Bar option under the Data Bars category. The selected conditional
formatting is applied to the selected cell range.
Prime (Ver. 2.2)-VII
24
Using conditional formatting
You can also define your own rule for highlighting cells by selecting New Rule option from
the Conditional Formatting drop-down list. The conditional formatting features applied to a
data range can be cleared by selecting Clear Rules option from the Conditional Formatting
drop-down list.
21 st
Century #Critical Thinking
Skills
Warm State whether these statements are True or False.
Up! 1. A Bar chart is a graph that shows vertical bars with the
axis values for the bars displayed at the left of the graph. _____
2. A Line chart is used to show a trend over time. _____
3. Excel can arrange data in ascending order only. _____
4. You cannot sort more than one columns at a time in a
selected range of cells. _____
5. The Add Level button is available under the Insert tab. _____
6. Sorting can also be done through Sort & Filter group
under the Data tab. _____
7. You can not define your own rule in Conditional Formatting. _____

