Enter in A1 =#VALUE!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?
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.
Like this thread? Share it with others