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

davidjearly

macrumors 68020
Original poster
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: 125
Anyone?

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

Cheers,

David
 
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: 86
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.