Hello!

I am analyzing bill of quantities by different bidders and for that I am using the conditional formatting. Unfortunately, when I enter a new rule for highlighting the MIN in green and MAX in red, some rows are not properly evaluated and I don't get any highlighted cell. [Image Can Not Be Found]

Can someone help me? Why some rows give a correct highlighting of MIN and MAX and other rows don't give any highlight?

Thanks!

Jernej