Conditional Formatting
 

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.

Conditional Formatting
 

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

replace A1 by your formula in both instances

"CK" wrote:

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.

Conditional Formatting
 

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

"Sheeloo" wrote:

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

replace A1 by your formula in both instances

"CK" wrote:

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.