Mac Office Excel question

Discussion in 'Mac Apps and Mac App Store' started by novetan, Mar 10, 2011.

  1. novetan macrumors 6502

    Joined:
    Sep 3, 2010
    #1
    I just installed Mac Office 2011.

    In Neo Office spread sheet, we can set global viewing size say from 100% to 150% with Format>Default formatting and it will affect every other sheet. Whereas in Mac Office Excel, Format>Conditional Formatting has to repeat for every sheet. That is a chore. Have I miss out somewhere?

    How do I set a global command?
    Thanks
     
  2. exegete77 macrumors 6502a

    Joined:
    Feb 12, 2008
    #2
    I don’t have Excel 2011, but worked with many previous incarnations of it (Win and Mac). I don’t think Conditional Formatting is what you want. That refers to automatically changing the format of the cell based on the value of the cell, not the viewing of the spreadsheet.

    My guess is that should be in the Preferences.
     
  3. novetan thread starter macrumors 6502

    Joined:
    Sep 3, 2010
    #3
    In Excel 2011, there is only a choice of Format>Conditional Formatting. All others in the drop down menu not relevant. And I can't see any thing relevant under Preferences
     

Share This Page