Page 279 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

6 Change the value of cell A1 to 81.
Result. Excel changes the format of cell A1 automatically.

Note: you can also use this category (see step 3) to highlight cells that are less than a value, between two values,
equal to a value, cells that contain specific text, dates (today, last week, next month, etc.), duplicates or unique
values.

Clear Rules:
To clear a conditional formatting rule, execute the following steps.
1 Select the range A1:A10.

266

CITS : IT&ITES - Computer Software Application - Lesson 63 - 77