Use conditional formatting to analyse data in Excel

An experiment using conditional formatting… I have a list of fictitious students who have taken an Excel exam this morning. The pass mark was 55, but I want to help the whole group to achieve a Grade B with a pass mark of over 70%. I want to be able to find who needs to […]