Switch To Product Links Languages Themes Feedback Sign Up Now
Loading...
Updating...
Please wait to edit...
Ready for editing X
Grade Sheet by zohosheet  14379 views
Print Export Copy to My Account Embed in Website/Blog
$ Macros
 
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
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.
SubjectScore (%)Grade
Mathematics
Physics
Chemistry
Language
Social Science
Sheet1
 
     
Processing...
Assign Macro Edit Label More