Suppose we had a spreadsheet with a person's name in cell A1 and a score in cell B1. We'd like to examine this score and see if it falls within a certain range. If it's 85 or above, for example, we'd like to award a grade of "GRADEA" either "GRADE B". We want this grade to appear in cell C1. As well as placing a grade in cell C1, we want to change the background colour of the cell.
excel macros,vba,vba tutorial,MACRO,macro excel,macro example,vba developer,MACRO LAST ROW,microsoft excel,microsoft,excel vba,excel vba tutorial,excel vba for beginners,excel vba loop,excel,microsoft excel (software),visual basic for applications,
Suppose we had a spreadsheet with a person's name in cell A1 and a score in cell B1. We'd like to examine this score and see if it falls within a certain range. If it's 85 or above, for example, we'd like to award a grade of "GRADEA" either "GRADE B". We want this grade to appear in cell C1. As well as placing a grade in cell C1, we want to change the background colour of the cell.
0 Comments