Mac Forum / Applications / Excel / May 2005

I need to do conditional formatting on more than 3 criteria. I have about 12
values I want to highlight w/ separate colors. Now, I can only select 3. If
I run those 3 (which successfully changes the highlight), the formatting is
deleted when I change the conditions and highlight ...

Whe have an excel file that is on a windows 2000 server.
-    When we open the file on a Mac OS X computer (Tiger 10.4.1) with
Excel 2004 (11.1.1), then on a Windows XP SP2 computer with Excel 2003.
We get the following error message: Cannot Access 'file.xls'.

How can I find the value of a variable in vb when debuging a program? I
have already selected the variable, passed the mouse, etc. and nothing
happens.  Any help will be appreciated.
----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----

I've been using Excel since 1.0, and I've never encountered this before
...
Excel:Mac v. X
OS X 10.3.9

I created templates in word on my mac for a client who is working on a
pc. The templates have excel worksheets pasted into them. When the
templates are opened in the pc world, the excel worksheets are all
screwed up, fonts, column widths, etc. I have a pc that i've been

When I upgraded to Office 2004, my custom Word key commands came across
but they didn't for Excel. Can anyone tell me how to get them across or
what v.X template ro pref file the commands are stored in?
Thank you.

Text box default
I have managed to change the Text box button default colour to orange and
cannot find how to change to another colour or revert to the default of no
colour ­ resetting the Drawing toolbar does not help - can you please?

I was wondering if there is a way to use countif or something similar
to count only visible cells.  I know of subtotal but to the best of my
knowledge there is no countif function tied to subtotal.  Basically i
have a column with a yes, no, and an n/a; I need to count how many of

Variables
I am using defined InsertionRow and InsertionCol variables to record row and
col in a spreadsheet
Is it possible to have a single variable, InsertionPoint, which will record

Cell line breaks
Alt+Return puts text on the next line within a cell (as manual line break in
Word)
I need to concatenate text from several cells into a single cell, keeping

I have a file with up to 11 seperate sheets. The sheets track the
results of team games, scores, points for and against and some other
stuff. I cut and paste special a link from each sheet to a seperate
sheet where i want to sort on the team results. Right now i copy the

I have just tried a Excel based application called qbase which was
clearly designed on a PC and just comes up with Automation error.  I do
not know a thing about VBA but can anyone give me any advice as to how
I might start going about trying to get this application working on my

I receive copyedited files from my employer's freelancer who uses both
Word 2002 and 1997 (depending on which computer she uses) for the PC
and I use Word 2004 for Mac. The tracked changes appear on the screen
as underline for insertions and strikethrough for deletions. I can

In a pc version of excel, I was comparing the rows of two documents,
which I had placed one above the other on the screen. By moving the
scroll bar in the top document, the bottom document would automatically
scroll at the same time (and vice-versa). There doesn't seem to be a

Ok, so I have this function repeated in a bunch of worksheets:
=MAX(F13:F94)&" min"
Sometimes I get the result I want "25 min" for example.  But sometimes
I get "25.29384932345 min".