Thanks, that formula works - i need to know only 2 more things - firstly, how do i make the whole row change to the formatted colour and not just the single cell with the lowest number and (here i think it gets complicated) the conditional format does not seem to apply when i filter the list of prices. how can i get this to work?