Conditional Formatting

  • Thread starter Thread starter CK
  • Start date Start date
C

CK

I have created a spreadsheet with 2 columns that I've created forumlas to
come up with percentages and basic production numbers. The error #DIV/0!
appears in the cell with the formula when no information is input into the
other cells that make up that formula. I want to hide that when no
information is available to complete the formula and unhide it when the
information is available automatically without changing formatting,
conditional or otherwise.

I figured out how to create the conditional format to show the text as white
when an error occurs, but I cant figure out how to turn that text back to
black (automatic) when there are numbers input to complete the formula.
 
Oddly enough the very next topic in the Help Section pointed me in this exact
direction. Thanks for your input.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top