A. Conditional Formatting:
Today I learned about 'conditional formatting' while creating a grade book in Excel. This is used to group numbers or cells into various colors based on any condition of your choice. To do this:
Highlight a range of cells, numbers, the table, or the whole sheet that you want to apply conditional formatting.
On the Home tab, click Conditional Formatting.
Click New Rule.
Select a style, for example, 3-Color Scale.
Select the conditions that you want, and then click OK.
B. The ''OR'' formula:
I also learned how to use the ''OR'' formula in Excel. This formula is used to ask a series of logical questions eg. Is a number less than another number. If it is, return 'True'. An example is seen below:
\=or(100%<.5,95%<.5)
The result of this formula will be true if either 100% or 95% is less than 0.5, and false if neither is less than 0.5. All cells that are 'True' will be highlighted.
C. Creating a Chart: We created different charts for different scores. To do this, the following was done:
Highlight the range of scores
Go to insert
Go to 'column chart'
Select clustered columns
Edit the title
To change the horizontal axis labels:
Right-click on the graph
Click on 'Edit'
Highlight the range of cells that include the labels you want.