Conditional formatting on Excel 2008

Discussion in 'Mac Apps and Mac App Store' started by R1CH4RD 21, Jul 31, 2009.

  1. macrumors newbie

    May 8, 2009
    I have Excel 2008 for mac. I have used conditional formatting to change the colour of a row when a specified field has a given name.

    The problem that I have is that I need to apply 7 different colours for different values, but you can only apply three different conditional formatting options to each cell.

    Does anyone know of a way to solve my problem?

  2. macrumors 6502a

    Feb 12, 2008

    If I am not mistaken, Excel 2007 has much higher conditional formatting. My understanding is that 2008 had the same capability.

    See if this helps: Conditional Formatting
  3. thread starter macrumors newbie

    May 8, 2009

    Its that menu "conditional formatting rules manager" that I cannot find. the menu style shown on that page is for windows base Excel, mac based has a different menu. :confused:
  4. macrumors 6502a

    Feb 12, 2008
    After further searching, I see that Excel 2008 does not have the additional capabilities.

    However, there is a hint here on how to extend: Excel 2008 Conditional Formatting
  5. thread starter macrumors newbie

    May 8, 2009
    It appears it is not possible to do what I want then! that site says its is possible up to six.
  6. macrumors 6502a

    Feb 12, 2008
    When I was working as an analyst for a Fortune 100 company, I had developed VBA to allow any number of conditions; based on a table on a separate worksheet that was hidden. It was instantaneous. Too bad VBA isn't available for 2008.

    You might consider using AppleScript or Python to achieve the same results.
  7. thread starter macrumors newbie

    May 8, 2009
    Ok thanks for the info. Im only a beginner when it comes to these things, thinks applescript etc may prove too complicated plus the end output has to be compatible with windows based machines. It seems crazy that microsoft would do away with something and not replace it...... I dont really know why im supprised!

    Apparently you can do it by using visual basic script in excel but they took away that facility as well!
  8. macrumors 6502a

    Feb 12, 2008
    Which means if you want to do it, then Python would be the way to go, since it works on Windows and Mac.
  9. thread starter macrumors newbie

    May 8, 2009
    Ok is there any particular site you would recommend to get a tutorial from? and also would I be able to run it through a programme like excel as work are unlikely to let me install more programs.
  10. thread starter macrumors newbie

    May 8, 2009
    I have found a way to do it for numerical values, is there any way I can link words to a numerical value?
  11. macrumors 6502a

    Feb 12, 2008
    You should be able to set up a helper column in which numbers are in column A and the words in column B.
  12. macrumors newbie

    Aug 13, 2009
    Getting back to the original question about conditional formatting, Excel 2007 is simply fabulous. It can do all you ask and more, including graduated colors based on their values, the ability to filter by color and sort by color.

    Excel 2008 is more like the old Excel 2003 and is appallingly slow just to make it worse, even after the recent SP2 update.

    I run Excel 2007 under Windows XP under VMware Fusion on my MBP (2.4 GHz with 4GB RAM) and I'm very, very happy with how it all works.

    Even under Fusion, Excel 2007 loads a largish workbook in 30 seconds that takes 12 minutes under 2008, and calculations run 3.5 times faster with 2007.

    But I would not try this without the 4GBs of RAM.
  13. macrumors 6502

    Jul 31, 2009
    Let me grab some code at work tomorrow. I remember setting up a heatmap in excel with some conditional formatting that produced a different RGB code for different criteria. Ill keep you posted.

Share This Page