I'm trying to set up conditional formatting on multiple columns to compare multiple prices and highlight the lowest value.

On the example sheet below. Row 2, the formula would compare the costs in B2, E2, and H2. H2 would be highlighted as the lowest cost.

I was able to do this by using the MIN Formula in column K and then using conditional formation to match the value of B, E, and H to that value, as seen in the example.

Is this possible to do within conditional format only or do the columns need to be next to each other to achieve this?

See the example sheet here: https://docs.google.com/spreadsheets/d/1PfTCO-nFhaofxdn13KtHurGnXBHin-NEjaMsRMC4_40/edit?usp=sharing

Thanks for any help!


1 Answer 1


You should be able to do a personalized formula like:


If you just want it to apply all B2:B, E2:E,HE:E ranges this conditionl formatting you can add:


I've tried it in a copy of your sheet in the spreadsheet you shared ;)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.