Page 33 - TP_Pluse_V2.2_Class_7
P. 33
Color Scales: This option is selected when you want to add colour
schemes to all selected cells slowly varying from top to bottom Factopedia
items. When you hover the mouse pointer over this option, it
opens a sub-list showing different colour variations that can be
added to cells.
Icon Sets: This option is selected when you want to add icon sets
to show which cells are acceptable, which are moderate and which
need attention. The different types of icon sets that can be added
are shown in the sub-list that opens when the mouse pointer is Freeze Panes feature
hovered over this option. allows you to lock
Step 3: Select the desired conditional formatting. In this case, we your column/row so
have selected the Orange Data Bar option under the Data that, when you scroll
Bars category. The selected conditional formatting is applied down or up to view
to the selected cell range. the rest of your sheet,
the locked column/
row remain on the
screen.
The earliest
Using conditional formatting
date allowed for
You can also define your own rule for highlighting cells by selecting calculations in Excel is
New Rule option from the Conditional Formatting drop-down list. January 1, 1900.
The conditional formatting features applied to a data range can
be cleared by selecting Clear Rules option from the Conditional
Formatting drop-down list.
Let’s BaCk-uP
Sorting data means to organise the data in ascending or
descending order.
If you need 1 second to
Custom sorting is used to apply sorting on more than one fill out 1 cell, it would
column in selected range on different criteria. take you 545 years to
The filters can be easily applied and removed according to the complete the whole
user’s requirements.
worksheet.
Conditional formatting can be applied on the basis of different
criteria.
Advanced Features of Excel 31

