change text color of #value error

[viper]

I can't seem to figure my problem out so I am going at it differently.

Can I change text color of the #value error?

My formulas work, when the link is complete the #value is replaced with the correct data. But when the linked cell is empty I get the #value error, no problem, I just don't my workbook with #value in empty cells.

I tried using conditional formatting and setting the text color to the cell color but that didnt' work. So is there another way to hide the #value error so users don't think my workbook is messed up?

 

[Aladin Akyurek]

On 2002-03-19 22:27, viper wrote:
I can't seem to figure my problem out so I am going at it differently.

Can I change text color of the #value error?

My formulas work, when the link is complete the #value is replaced with the correct data. But when the linked cell is empty I get the #value error, no problem, I just don't my workbook with #value in empty cells.

I tried using conditional formatting and setting the text color to the cell color but that didnt' work. So is there another way to hide the #value error so users don't think my workbook is messed up?

Enter in A1 =#VALUE!
Activate A1.
Activate Format|Conditonal Formatting.
Choose 'Formula Is' for Condition 1.
Enter as formula:

=ISERROR(A1)

Activate Format.
Choose white as color on the Font tab.
Click OK, OK.

 

[Jay Petrulis]

Hi Viper,

When you say you tried using Conditional Formatting, what exactly did you use? Did it fail, or did it not produce the desired result?

Conditional formatting can be used to identify #VALUE! errors.

Format>Conditional Formatting
Formula Is
=ERROR.TYPE(your range)=3

and however you want to display it.

HTH,
Jay

 

[viper]

Thank you both. I've been trying to get this project done for a month and that was the last thing I needed to fix before final testing of all formulas and calculations.

Thanks again,
viper