Hey,

So I am currently using this to highlight a row based on the cell.

=$J3<>""

But when I try it on another cell which has a formula in it. its highlighted every row because of a 0 in the cells all the way down. is there a way to avoid the 0? i've done hide 0's via the option but it still detects it as there.

any suggestions on how to avoid 0? probably so simple but my mind has gone blank.

thanks