Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

How to CREATE a green triangle in EXCEL

  1. Oct 4, 2012 #1
    On the internet there is only information on how to get rid of the trianglethat indicates an error in the formula in the cell.

    But in my workplace I need to upload data to a program and sometimes a succesful upload requires that the data in my excel cells be marked by this error-triangle.

    How to mark multiple cells with it. I only know that you have to enter a number, choose text format in the home tab "number" section and to press smth. Can any one tell? :)
     
  2. jcsd
  3. Oct 9, 2012 #2

    mfb

    User Avatar
    2016 Award

    Staff: Mentor

    I would try to find and fix the source of that, instead of an attempt to use a bug of unknown source and behavior.
     
  4. Oct 9, 2012 #3
    If i remember correctly (been a while since i've used excel) the small green triangle indicates inconsistant data

    For example
    =A1+B1+1
    =A2+B2+2
    =A3+B4+3 (green triangle)
    =A4+B4+4
    =A5+B5+5

    Strange that they would require inconsistant data unless all the formula's are entered manually.

    If this is the case i would have to agree with mfb, if not re enter the information with inconsistant formulas with the same results.

    example
    original data
    =1
    =2
    =3

    changed data to give error triangles
    =1+2-2
    =2
    =3-3+3

    Personally i would just change the highlight colour to green to show what ones are ment to have the triangle...

    Overall its a very strange thing to require in my opinion.
     
    Last edited: Oct 9, 2012
  5. Oct 10, 2012 #4
    after doing a fair bit of excel today at my work place (updating reports for universities) the green number only shows up when numbers are formatted as text. in my opinion if you want it to show up select the whole table and right click format, as text. alternatively save as a .csv file and then reopen in excel, this removes all formatting effectively then save again as the required file format. this may fix any uploading issues ect.
     
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook




Similar Discussions: How to CREATE a green triangle in EXCEL
Loading...