Conditional Formatting - Highlight row based on cell

[LeeBillington]

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

[Pete_UK]

Try this rule instead:

=AND($J3<>"",$J3<>0)

Hope this helps.

Pete

[LeeBillington]

Worked perfectly, thank you I appreciate it

[Pete_UK]

Glad to help, Lee - thanks for the rep.

Pete