Color scale avoiding zero

[Pablo Santiago Díaz]

Hi!

I'd like to create a color scale in my Excel 2013 sheet highlighting the smallest value on green and the highest on red. I can do it using conditional formats and selecting color scales, my problem is that some cells have the value 0, and I'd like to prevent the formula to being applied to them. Any suggestion?

Thanks!

[#2]

You can apply a rule that cells that equal "0" or maybe "Less than one" are not highlighted. 

https://www.ablebits.com/office-addins-blog/2014/05/29/use-conditional-formatting-excel/

Good detailed article on the topic. 

I hope this helps!