In a separate module $($insert$/$create another module$),$ based on the value of the score, use IF construction and loop to create a sub procedure to change the font color of the score $($one color for each range of the score$).$ You may use any colors you like: score $=9085$ score $<9075$ score $<8565$ score $<75$ below $65,$ do not change the font color. Please be noted: when you save your work, make sure you save it as the xism format $($i$.$e$.$ macro$-$enabled workbook$).$ This is very important, otherwise you may lose all the macros$/$codes$.$