Hello, i am very basic when it comes to Excel, but i am at work and i have been asked to make up a spreadsheet which i have done, but i fall flat when i need to highlight the 3rd lowest number from a group of cells. this would give me the 3rd lowest average number which is used as a measuring stick.

i.e cells d7:d26, are average numbers of the corresponding rows they are on, what i need to do is auto highlight the 3rd lowest number in that column. I have played abit and have managed to highlight the 3 lowest numbers but i only want to hoghlight the 3rd lowest number .

Is this possible?

thanks