Conditional Formatting

[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.

 

[Sheeloo]

Try
=IF(ISERROR(A1),"",A1)

replace A1 by your formula in both instances

 

[CK]

Oddly enough the very next topic in the Help Section pointed me in this exact
direction. Thanks for your input.