I have a table in Excel, say, which has grade/subject/standards
columns, shown as following:
subject grade standards
Math 3 A
Math 3 B
Math 3 C
Reading 3 A
Reading 3 B
Reading 3 C
Reading 3 D
Math 4 A
Math 4 B
Math 4 C
Reading 4 A
Reading 4 B
Reading 4 C
Reading 4 D
I want to put the rows where subject="Math" & grade="3" with grey
background, the rows where subject="Reading" & grade="3" with white
background. Again, the rows with subject="Math" & grade="4" with grey
background. In a word, the purpose is to distinguish different grade
subject info by using different background colors (BTW, the number of
rows for each grade subject varies, cannot be known in advance). How
to do this kind of formatting in VBA macros?

A further question would be: when the by groups varies, how to do it?
Say, the above example I need to consider both subject and grade
columns to do formatting, what if next time, I only need to
distinguish the rows by subject (no grade info needs to be
considered).

Thank you in advance!
-Wendy