Hi, I am trying to format a column that has blank cells and cells with %'s. I have tried to use the formatting to highlight any cell that is >1% in light green, but what happens is that the blank cells are highlighted in green and the cells with the % are left blank. Tried to use the formula option first to leave blank cells with no format, but still does not work.

Can anyone help please?