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?
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?