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

R1CH4RD 21

macrumors newbie
Original poster
May 8, 2009
27
0
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?

Thanks
Richard
 
Howdy.

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


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:
 
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.
 
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!
 
Which means if you want to do it, then Python would be the way to go, since it works on Windows and Mac.
 
Which means if you want to do it, then Python would be the way to go, since it works on Windows and Mac.

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.
 
I have found a way to do it for numerical values, is there any way I can link words to a numerical value?
 
You should be able to set up a helper column in which numbers are in column A and the words in column B.
 
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.
 
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.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.