Excel: Conditional formatting of cells based on formula result not equalling zero


I want to highlight cells containing formulas based on the result of the formula not equalling zero. Two columns

Column I Column J
Account Name 1 $0.00
Account Name 2 $20.00
Account Name 3 $0.00
Account Name 4 ($10.00)
Column J contains a VLookup formula. I know I need to use a formula in conditional formatting, but can't get it working. Any suggestions?


This question generated 14 answers. To proceed to the answers, click here.

This thread is current as of March 20, 2017.


For more resources for Microsoft Excel