Version: 2008
Operating System: Mac OS X 10.4 (Tiger)
Processor: Intel
Hello, I'm writing because I've a problem. I've 5 Variable and I need that they have to be colored in 5 different and automatic color. If I write "MA" dei have to be pink, If I write "GI" it have to be Yellow. But In my Excel I can use only 3 possibility and not more, so how I can do to increasy on my work up to 5 variable color? Thank you in advance for your answer
|
|
0
|
|
|
|
Reply
|
 nuvolare
|
12/4/2009 10:47:42 PM |
|
In Excel 2008, you need to write an AppleScript to do this. I can't tell
you how to do that.
Most of the utilities you see on the Internet require VBA, and Excel 2008
does not have that.
Excel 2010 for Mac, due next year, will have VBA, and will also probably
allow more colours for conditional formatting.
Sorry
On 5/12/09 9:47 AM, in article 59bae31f.-1@webcrossing.JaKIaxP2ac0,
"nuvolare@officeformac.com" <nuvolare@officeformac.com> wrote:
> Version: 2008 Operating System: Mac OS X 10.4 (Tiger) Processor: Intel Hello,
> I'm writing because I've a problem. I've 5 Variable and I need that they have
> to be colored in 5 different and automatic color. If I write "MA" dei have to
> be pink, If I write "GI" it have to be Yellow. But In my Excel I can use only
> 3 possibility and not more, so how I can do to increasy on my work up to 5
> variable color? Thank you in advance for your answer
--
The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!
John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410
+61 4 1209 1410, mailto:john@mcghie.name
|
|
|
0
|
|
|
|
Reply
|
John
|
12/5/2009 7:18:21 AM
|
|
Have a look here. It may give you what you need:
http://mcgimpsey.com/excel/conditional6.html
HTH |:>)
Bob Jones
[MVP] Office:Mac
On 12/4/09 5:47 PM, in article 59bae31f.-1@webcrossing.JaKIaxP2ac0,
"nuvolare@officeformac.com" <nuvolare@officeformac.com> wrote:
> Version: 2008 Operating System: Mac OS X 10.4 (Tiger) Processor: Intel Hello,
> I'm writing because I've a problem. I've 5 Variable and I need that they have
> to be colored in 5 different and automatic color. If I write "MA" dei have to
> be pink, If I write "GI" it have to be Yellow. But In my Excel I can use only
> 3 possibility and not more, so how I can do to increasy on my work up to 5
> variable color? Thank you in advance for your answer
|
|
|
0
|
|
|
|
Reply
|
CyberTaz
|
12/5/2009 1:57:01 PM
|
|
|
2 Replies
154 Views
(page loaded in 0.033 seconds)
Similiar Articles: Conditional formatting based on length of the cell contents ...Hi all A customer is using Excel to define data which will later be mangled into a database, but they have a habit of putting in strings that are ... Conditional Format, Color Scale adjacent cells - microsoft.public ...I have a list of companies from which I receive periodic reports. Each company has a weight of importance In my list I record the incoming reports s... conditional formatting label?? - microsoft.public.access ...How do you write code to format label of checkbox? I have a checkbox that I would like to have the text label turn yellow if checkbox is True. I ha... Conditional Formatting In a Datasheet Form - microsoft.public ...Hi All, I am trying to “Condition Format” a column on my form so it will highlight the individual cell if another cell in the same column has the sa... Conditional format on adjacent cells - microsoft.public.excel ...Hi All, what am I doing wrong?? I want cells A1 to G1 to conditionally format (to red) if they are ALL empty, but if ANY one (or more) of them con... conditional formatting of a percent - microsoft.public.access ...I would like to use Conditional formatting on a percent field that is calculated in my report. The text box field contains the formula =[TotNot]/[T... Conditional Formatting: Change .BackColor on-the-fly? - microsoft ...I've got some fields whose .BackColor gets changed by code. But they also have conditional formatting on them. For instance, if the trade type = Buy... Conditional Formatting - More than 3 Options - microsoft.public ...I have a database that has information for the past 5 years and will continue on. I need to color code the background of the box depending on the va... Conditional Formatting -- Need VBA Code - microsoft.public.access ...Hi, Can someone help me out with some starting VBA code for conditional formatting? (I need more than the three conditions that the built-in f... Conditional Formatting in Reports - microsoft.public.access ...I have an inventory table which is updated from a form. This form contains several fields giving details about each type of machine. One of these fi... Conditional FormattingHow to use Conditional Formatting in Microsoft Excel97 and Excel2000 to format cells based on their content, or the content of other cells. Excel Conditional Formatting IntroductionExcel Conditional Formatting -- Introduction What is Conditional Formatting? Apply Conditional Formatting to a Cell; Excel Conditional Formatting -- Based ... How to Apply Conditional Formatting in Excel: 16 stepsHow to Apply Conditional Formatting in Excel. Do you ever need to know when you are over or under budget? Want to pick out an important data from a huge list? Excel's ... Conditional Formatting - Welcome to the MVPs.org home page!Conditional Formatting, while in effect for a cell, will override normal interior, text, and number formatting colors. A terrific feature with some severe limitations ... Conditional Formatting: Adding Customized Rules to Excel 2007Summary: The conditional formatting user interface (UI) in Excel 2007 now makes it easier than ever to create rules that increase the impact of your data. Learn how ... 7/4/2012 1:22:28 PM
|
Search |
Post Question |
Groups |
Stream |
About |
Register
14 followers. 