Conditional format

N

nuvolare

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
 
J

John McGhie

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

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:[email protected]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top