I need to determine if an employee passed or failed an exam, this is the current formula that I am using;
=IF(J2>=90, "P", IF(J2>=80, "N", IF(J2<=79, "F", )))
Now I want the response (P, F, N) to show up a specific color, for example: Red = Fail, Green = Pass, Yellow = Needs...