Data Handling
Part 3
Conditional Formatting
Conditional formatting in Excel lets you automatically change the appearance of
cells based on their values. For instance, you can highlight cells with different
colours depending on whether their values meet certain criteria, such as being
above or below a specific number. This helps to visually emphasize important
data and trends.
Highlight Cells Rules
To highlight cells that are greater than a value, execute the following steps:
1. Select the range A1:A10.
2. On the Home tab, in the Styles group, click Conditional Formatting.
By: Fatima Adnan
, 3. Click Highlight Cells Rules, Greater Than.
4. Enter the value 80 and select a formatting style.
5. Click OK and Results will be highlighted for cells that are greater than 80.
6. Try applying other sorts of conditional formatting on your data.
By: Fatima Adnan
Part 3
Conditional Formatting
Conditional formatting in Excel lets you automatically change the appearance of
cells based on their values. For instance, you can highlight cells with different
colours depending on whether their values meet certain criteria, such as being
above or below a specific number. This helps to visually emphasize important
data and trends.
Highlight Cells Rules
To highlight cells that are greater than a value, execute the following steps:
1. Select the range A1:A10.
2. On the Home tab, in the Styles group, click Conditional Formatting.
By: Fatima Adnan
, 3. Click Highlight Cells Rules, Greater Than.
4. Enter the value 80 and select a formatting style.
5. Click OK and Results will be highlighted for cells that are greater than 80.
6. Try applying other sorts of conditional formatting on your data.
By: Fatima Adnan
