Page 63 - TP_Modular_V2.1_Class7
P. 63
• Data Bars: This option is selected when you want to add data bars to the cells
having numeric data. When you hover mouse over this option, it opens a sub-list
showing bars of different types and colours that can be added to the cells.
• Color Scales: This option is selected
when you want to add colour schemes
to all selected cells slowly varying
from top to bottom items. When
you hover mouse over this option,
it opens a sub-list showing different
colour variations that can be added
to cells.
Using Conditional Formatting
• 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 is hovered over this option.
The selected conditional formatting is applied to the
selected cell range. 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.
Conditional Formatting applied
USING DATA VALIDATION
Data validation means to restrict the user to enter a specific range of values in a particular cell or
a range of cells. Perform the following steps to use data validation:
Step 1 Select the cell or a range of cells on which you want to apply data validation.
Step 2 Click on the Data Validation command from the Data Tools group of the Data tab. A
drop-down list appears.
Step 3 Select the Data Validation option. The Data Validation dialog box appears with the
Settings tab selected.
Data Validation Data Validation dialog box
Excel as Database 61

