Forum Discussion
Color scale avoiding zero
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...
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!