Forum Discussion

Pablo Santiago Díaz's avatar
Pablo Santiago Díaz
Copper Contributor
Nov 25, 2017

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 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!

 

 

excel
office 365

1 Reply

  • Hunter Willis's avatar
    Hunter Willis
    Iron Contributor
    Nov 28, 2017

    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!