Use VBA Macros to create a grading system in excel. 2 new columns should be created where one would be grades with their respective color background and another would be comment on the grade. All of...

76647/GradingSystem.xltm
Sheet1
        Name        %        Grade        Comment
        Venice Shepherd        60        F        Failed class

        Ma Ketelsen        92        A-        Congratulations!
        Arvilla Dungy        94        A-        Congratulations!
        Phebe Pendarvis        66        D+        Worst Performance
        Kerrie Rowser        89        B+        Great Effort!
        Lula Kinkade        85        B+        Great Effort!
        Wilson Bou        98        A+        Congratulations!
        Chauncey Davidson        68        D+        Worst Performance
        Gabriela Slonaker        99        A+        Congratulations!
        Benjamin Laramore        82        B-        Great Effort!
        Sau Imai        78        C+        You could have done better
        Maia Lazos        91        A-        Congratulations!
        Helga Slick        88        B+        Great Effort!
Get Grades
Get Grades
76647/VBCode.txt
Private Sub CommandButton1_Click()
Dim rangeColumns As Range:
Set rangeColumns = Application.Range("B2:B14")
Dim percentColumn As Range
For Each percentColumn In...