Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: change text color of #value error

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Jefferson City, Missouri
    Posts
    382
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?


    I appreciate the help from everyone at Mr. Excel.

    viper

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,655
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    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.


  3. #3
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Jefferson City, Missouri
    Posts
    382
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •