Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

davidjearly

macrumors 68020
Original poster
Sep 21, 2006
2,271
382
Glasgow, Scotland
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
 

Attachments

  • ss.JPG
    ss.JPG
    5.6 KB · Views: 106
i dont really get your question, can you post a step by step description?
 
Anyone?

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

Cheers,

David

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.
 

Attachments

  • Capture.JPG
    Capture.JPG
    56.9 KB · Views: 55
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.