Hide Zero Values By Using Conditional Formatting

October 14, 2008 by
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.


Tell me what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!

You must be logged in to post a comment.