Most valuable professional
  • Hot Topics

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 Account Name 1 Account Name 2 Account Name 3 Account Name 4 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? Last edited by elemenopee; Yesterday at 07:32 PM.

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:

This article includes the following tags:

  • Excel
  • Microsoft Excel