Page 79 - Penta Book's ICT Catalogue
P. 79
Conditional formatting
When you want to change the way your cells look based on what they contain, you can apply conditional
formatting. First, you specify certain conditions, and your cell appearance will change to meet these conditions.
To apply Conditional 2
Formatting:
> Select the cells which you
want to apply conditional
formatting to, for example
B3 to C10. 1
> On the Home tab, in
the Styles group, click
Conditional Formatting. 2 3
> Click New Rule. 3
> You can select the criteria 1
you want to use, for example contain to create rules and format
Use Format only cells that
click Format only cells that
Computing and ICT . Sample Pages DIGITAL TEENS 2 MODULE 5 > Type 10 to 20. 5 4
your cells based on these.
contain. 4
> Click Format and format
the cells accordingly. 6
> Click OK. 7
/ Advanced charts 5. Analyzing data / Advanced charts 5. Analyzing data / Advanced charts / Advanced charts
8 5
GRADE 6 7
hands on!
Type the following table; add a pie and a
column chart. Change the fill colors and
the axis names in the chart.
78 Penta Books
