Conditional formatting in Excel_Strange behaviour
Mon, 22 Feb 2010 22:31:01 -0800
Hi to everyone.
I have a column in an Excel sheet , letâ??s say A1:A10 where
A1:A10=1,2,3,4,5,6,0,ABC,9,10 and all the cells of A column have been
declared as text.
I would like to apply conditional formatting with multiple criteria as
follows:
1) = not(isnumber(value(A1))) the cells to change in red color ...
|
DIsplaying negative time values
Mon, 22 Feb 2010 18:00:11 -0800 (PST)
Hi,
I have two columns of time values. I need to determine the difference
between the two values and return either a positive or negative time
value. The table below is in hours and minutes
Time A Time B
09:00:00 09:00:00
09:00:00 09:03:00
09:00:00 08:58:00
In t ...
|
Editing Excel Worksheets Online
Mon, 22 Feb 2010 11:03:25 -0500
I work with an informal coalition of small non-profits. The group would like
to be able to share a handful of Excel spreadsheets via the Internet, with a
few members having online edit capabilities and the remainder being able to
read and download them. We have access to a website, but the hosting
provider r ...
|
Function to mapping data
Mon, 22 Feb 2010 08:01:35 -0800 (PST)
Hi all,
I am struggling for an excel data combination. Hope someone can help
me.
Below col A and Col B is a pair while col C and col D is another pair,
originally col E, F and G are empty.
Then in col E, col F , col G, they copy Ax+Cx(eliminate duplicate),
Bx, Dx respectively.
A B C D E F G
C1 AA C1 111 C ...
|
A Macro to Print sheets in mult w.books
Mon, 22 Feb 2010 05:08:01 -0800
Hi there, can anyone help me with the codes to get a macro to print local
wbook sheets along with the several sheets in other workbooks? I was able to
record a macro to print worksheets in the local workbook, but how do i make
the same macro to print the worksheets in three more different workbooks with
mult ...
|
Is RowHeight=0 the same as Hidden
Mon, 22 Feb 2010 12:55:51 -0000
I'm manipulating rows, and I want to know if I can distinguish between rows
that have been hidden, and rows that have been set to RowHeight = 0.
Thanks
M
...
|
Changing Parameters by changing a cell
Mon, 22 Feb 2010 04:52:01 -0800
When importing data using a WEB QUERY in EXCEL 2003
http://www.metoffice.gov.uk/weather/europe/berlinforecast.html
I get the weather for berlin etc.
I then put a parameter in ["city"] so I get
http://www.metoffice.gov.uk/weather/europe/["city"]forecast.html and link
this to a cell
that I can ...
|
|
|
Automating filters
Mon, 22 Feb 2010 02:13:50 -0800
Hi
Followed this thread and used the example to great effect. However If i wanted to automate against a number of different filters in the datasheet ie Range A1:A2 and range B1:B2 looking at different columns to combine a view - is that possible ?
thanks
Keith
Dave wrote:
Re: Can Advanced Filter be ...
|
Mutilanguage in functions
Mon, 22 Feb 2010 11:01:34 +0100
For Excel 2007, is there any way to make it possible to write the Fuctions
in many languages? For the moment I am on a Swedish version of Excel 2007,
but I would like to write the fuctions in English, and then later bring it
to a French computer.
...
|
Exporting to CSV with embedded line breaks
Sun, 21 Feb 2010 22:33:28 +0100
Hi!
I want to save a file as a CSV format with embedded line breaks. When I save
it now I see each row in excel as a separate line in the CSV file. The file
should show the records on one line separated by embedded line breaks.
Can any one out there help me?
Thanks a lot.
Peter
...
|