Page 57 - ModularV1.1 _c7_flipbook
P. 57
Colour Scales – This option is selected when you want to add colour schemes to all
the selected cells slowly varying from top to bottom items. When you hover the mouse
over this option, it opens a sub-list showing different colour variations that can be
added to the 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 is hovered over
this option.
Using Conditional Formatting
The selected conditional formatting is applied to the
selected cell range. You can also define your own rule for
highlighting cells by selecting the New Rule option from
the Conditional Formatting drop-down list.
The conditional formatting features applied to a data
range can be cleared by selecting the 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 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.
Step 4 Select the desired option from the Allow
drop-down list. In this case, we have selected
Whole number option.
Step 5 Enter the minimum and maximum values in the
Minimum and Maximum textboxes. In this case,
we have typed 1 and 31 respectively.
Data Validation dialog box
Excel as Database 55

