Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Reply
 
Thread Tools Search this Thread Display Modes
Old Jul 31, 2009, 01:21 PM   #1
R1CH4RD 21
macrumors newbie
 
Join Date: May 2009
Conditional formatting on Excel 2008

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
R1CH4RD 21 is offline   0 Reply With Quote
Old Jul 31, 2009, 01:29 PM   #2
exegete77
macrumors 6502a
 
Join Date: Feb 2008
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
__________________
iMac 21.5 MBP 13" retina (since 1990)
old, slow, and confused
but at least I'm inconsistent!
The missing missing and challenges of a loved one missing
exegete77 is offline   0 Reply With Quote
Old Jul 31, 2009, 01:37 PM   #3
R1CH4RD 21
Thread Starter
macrumors newbie
 
Join Date: May 2009
Quote:
Originally Posted by exegete77 View Post
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.
R1CH4RD 21 is offline   0 Reply With Quote
Old Jul 31, 2009, 01:37 PM   #4
exegete77
macrumors 6502a
 
Join Date: Feb 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
__________________
iMac 21.5 MBP 13" retina (since 1990)
old, slow, and confused
but at least I'm inconsistent!
The missing missing and challenges of a loved one missing
exegete77 is offline   0 Reply With Quote
Old Jul 31, 2009, 01:41 PM   #5
R1CH4RD 21
Thread Starter
macrumors newbie
 
Join Date: May 2009
Quote:
Originally Posted by exegete77 View Post
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
It appears it is not possible to do what I want then! that site says its is possible up to six.
R1CH4RD 21 is offline   0 Reply With Quote
Old Jul 31, 2009, 01:55 PM   #6
exegete77
macrumors 6502a
 
Join Date: Feb 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.
__________________
iMac 21.5 MBP 13" retina (since 1990)
old, slow, and confused
but at least I'm inconsistent!
The missing missing and challenges of a loved one missing
exegete77 is offline   0 Reply With Quote
Old Jul 31, 2009, 03:14 PM   #7
R1CH4RD 21
Thread Starter
macrumors newbie
 
Join Date: May 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!
R1CH4RD 21 is offline   0 Reply With Quote
Old Jul 31, 2009, 03:18 PM   #8
exegete77
macrumors 6502a
 
Join Date: Feb 2008
Which means if you want to do it, then Python would be the way to go, since it works on Windows and Mac.
__________________
iMac 21.5 MBP 13" retina (since 1990)
old, slow, and confused
but at least I'm inconsistent!
The missing missing and challenges of a loved one missing
exegete77 is offline   0 Reply With Quote
Old Jul 31, 2009, 03:22 PM   #9
R1CH4RD 21
Thread Starter
macrumors newbie
 
Join Date: May 2009
Quote:
Originally Posted by exegete77 View Post
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.
R1CH4RD 21 is offline   0 Reply With Quote
Old Jul 31, 2009, 03:32 PM   #10
R1CH4RD 21
Thread Starter
macrumors newbie
 
Join Date: May 2009
I have found a way to do it for numerical values, is there any way I can link words to a numerical value?
R1CH4RD 21 is offline   0 Reply With Quote
Old Jul 31, 2009, 09:21 PM   #11
exegete77
macrumors 6502a
 
Join Date: Feb 2008
You should be able to set up a helper column in which numbers are in column A and the words in column B.
__________________
iMac 21.5 MBP 13" retina (since 1990)
old, slow, and confused
but at least I'm inconsistent!
The missing missing and challenges of a loved one missing
exegete77 is offline   0 Reply With Quote
Old Aug 13, 2009, 09:57 PM   #12
thepossum
macrumors newbie
 
Join Date: Aug 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.

Last edited by thepossum; Aug 13, 2009 at 10:06 PM.
thepossum is offline   0 Reply With Quote
Old Aug 13, 2009, 11:00 PM   #13
OnYourKnees
macrumors 6502
 
Join Date: Jul 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.
OnYourKnees is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
Chart in excel 2008 grkprncezz Mac Applications and Mac App Store 0 Oct 21, 2013 09:32 AM
[Excel 2011] Conditional Formatting Prohybe Mac Applications and Mac App Store 0 Jul 24, 2013 12:27 PM
Formatting Excel Date Error RatHat Mac Applications and Mac App Store 2 Jun 28, 2013 09:44 PM
Office 2008 Excel fluidlives Mac Basics and Help 2 Aug 30, 2012 04:40 AM
MS Excel 2008 Help mic j Mac Applications and Mac App Store 0 Aug 13, 2012 01:47 PM

Forum Jump

All times are GMT -5. The time now is 12:15 PM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC