Hi Craig

Mark the whole range of data that you want the CF to apply to e.g. A2:M10
In the formula for the conditional formatting, instead of MIN() use SUBTOTAL(5,)

=$A2=SUBTOTAL(5,$A$2:$A$10)
Change ranges to suit.

Regards

Roger Govier


craigproudfoot wrote:
> 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?
>
>