Hide Zero Values By Using Conditional Formatting

Filed under: Excel 
  1. Choose the cell or cells containing the zero value.
  2. Click the Conditional Formatting option from the Format menu.
  3. Select Cell Values Is from the left-most list box.
  4. Then, select equal to from the second list box from the left.
  5. Enter the number zero from the right-most list box.
  6. Click the Format button and then select the Font tab.
  7. excel conditional formatting
  8. Click the down arrow under Color then choose white as the color.
  9. Click the OK button twice.


Leave a Reply

You must be logged in to post a comment.