Currently I'm using the top/bottom conditional rule formatting so that the highest figure is displayed in green and the lowest in red (as shown below). The issue is, as I have a set of data that is made up of 20 or 22 entries depending on what the user selects in the dropdown menu, there is an issue getting the conditional formatting to adapt to this. I can't seem to enter an IF statement for the top/bottom values option, so I'm unaware how I can achieve this. Only the first 20 rows of the data can be potentially highlighted but I want it so it adapts when there are 22 rows.
http://oi43.tinypic.com/2wbzy8h.jpg
Bookmarks