Hi All,
New to this forum and was looking for some guidance please with conditional formatting in excel.
Im a beginner with excel and have managed to put together the attached spreadsheet to collect student test data.
I've managed to do the lookups to find a grade for each test result but what I'm struggling with is how to colour the test grade either RED (if it is below target), AMBER (if it is on target) or GREEN (if it is above target) according to how it compares to their TARGET grade (column I) on the combined worksheet.
I have tried may variations by watching YouTube videos but I haven't managed to get it to work yet. Is there anyone who could guide me please.
Your help would be very much appreciated
Sarb
CONDITIONAL FORMATTING.xlsx
Bookmarks