Excel Help

Discussion in 'Mac Apps and Mac App Store' started by davidjearly, Apr 22, 2009.

  1. davidjearly macrumors 68020

    davidjearly

    Joined:
    Sep 21, 2006
    Location:
    Glasgow, Scotland
    #1
    Hi,

    As in the screenshot below, I am trying to make cells in Excel 2007 (Windows) display an arrow depending on the difference which results from the calculation.

    Any help?

    Cheers,
    David
     

    Attached Files:

    • ss.JPG
      ss.JPG
      File size:
      5.6 KB
      Views:
      74
  2. davidjearly thread starter macrumors 68020

    davidjearly

    Joined:
    Sep 21, 2006
    Location:
    Glasgow, Scotland
    #2
    Anyone?

    I don't think this can be done on Office for Mac but I have seen it in Office 2007 Windows.

    Cheers,

    David
     
  3. clevin macrumors G3

    clevin

    Joined:
    Aug 6, 2006
    #3
    i dont really get your question, can you post a step by step description?
     
  4. gauchogolfer macrumors 603

    gauchogolfer

    Joined:
    Jan 28, 2005
    Location:
    American Riviera
    #4
    Using Conditional Formatting, select a new rule for the cell and choose format style "Icon Sets". Then you should see something that lets you pick arrows, stoplights, etc.
     

    Attached Files:

  5. davidjearly thread starter macrumors 68020

    davidjearly

    Joined:
    Sep 21, 2006
    Location:
    Glasgow, Scotland
    #5
    Thanks gaucho. Will try that and report back!
     

Share This Page