| |
Conditional Formatting using Macros |
|
| |
Enter the score (eg: 82) in the Score column. If the score is less than 50, it will highlight the grade in Red. And if it is greater than 90, it will highlight the grade in Blue.
Click on the Macros menu, select VBA Editor and click on Sheet1 in the tree to view the script for this macro. |
|
| |
|
|
|
|
| |
Subject |
Score (%) |
Grade |
|
| |
Mathematics |
|
|
|
| |
Physics |
|
|
|
| |
Chemistry |
|
|
|
| |
Language |
|
|
|
| |
Social Science |
|
|
|
| |
|
|
|
|
|