I am applying a simple conditional format to column of values that formatted as currency. I am trying any cells that are "$0.00".

I have the conditional format for a "Highlight Cell, Equal To"and the value to equal is 0.

This cause any blank cells to become conditionally formatted as well. Is there way to not condition blank cells when looking for a zero value?


Just create a new rule for blank cells, and put them above the old rule (means it will take priority over your rule).

  1. Create a new rule
  2. Insert =ISBLANK(A1). Modify A1 to your top-left cell in range.
  3. Don't put any format.
  4. Click Conditional Formatting > Manage Rules
  5. Select your new rule and click ^ arrow.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.