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 6502
 
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 6502
 
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 6502
 
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 6502
 
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 6502
 
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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
thread Thread Starter Forum Replies Last Post
Macros on Excel 2008 for Mac Natasha68 Mac Basics and Help 2 Aug 20, 2011 06:44 AM
Chart update on Excel 2008 barnetda Mac Applications and Mac App Store 2 Jun 16, 2011 11:36 AM
Microsoft Excel 2008 question. Hylekmi Mac Applications and Mac App Store 1 Jan 26, 2011 05:52 PM
help with excel for mac 2008 damiang72 Mac Applications and Mac App Store 0 Nov 14, 2010 06:19 AM
Excel 2008 - How to disable auto formatting cells completely? feuerschlange Mac Applications and Mac App Store 0 Jun 30, 2009 07:26 PM


All times are GMT -5. The time now is 02:00 PM.

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

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