|
how give excel cell red color if value above range?
Hi all.
I'd like to know how I can affect a color (especially rad) to some Excel box
if the value, coming from a formula) is out of a certain range?
Ex: if my %error is comprised between -5% and + 5%, then no color but if it
is out of this range, then teh cell would appear RED...
Ty all for any advices.
BR,
Julien...
|
3 |
28.09.2006 13:18:02 |
|
|
select only used rows and only visible cells
I've used the following macro by Frank Kabel to select only usedrows
but as I'm dealing with subtotals (level 2 so only the subtotals
themselves are visible) I only want to copy the visible rows. How do I
go about doing that?
Before the Copy command I've specified -
Selection.SpecialCells(xlCellTypeVisible).Select - but it still copies
all the used rows not the visible cells only
"Sub...
|
3 |
28.09.2006 13:06:54 |
|
|
Cannot save or export XML data??
When I tried to export a range to XML in excel 2003, it pops out an
error message:
Cannot save or export XML data. The XML maps in this workbook are not
exportable.
I tried to verify the schema, it turns out:
xxx_Map is not exportable because it contains the following:
.. List of lists
.. A mapped element's relationship with other elements cannot be
preserved
The schema also contains ...
|
1 |
28.09.2006 13:03:21 |
|
|
Excel not opening properly
I apologize if I posted this before. I know I did in Access, but I meant to
post in Excel.
Been having computer problems - found worms and trojans and still in the
process of recovering my computer settings.
Excel won't open properly. When I click on an Excel file, the program
"opens", but the file does not. I have to go to file, open, and find the
specific Excel file AGAIN, and ope...
|
7 |
28.09.2006 12:54:02 |
|
|
Variance
Hi, I would like to get a waring in a ell that if one cell has a higer OR
lower value than another specific cell (decided by me).
I want to use percent to specify the variance. If cell A1 differs up OR down
from cell A2 with more than 20% I want it to return lets say a "!".
/FReddie...
|
6 |
28.09.2006 12:41:57 |
|
|
Screen "Flashing" on Window change
A couple of days ago I made a change somewhere and now I can't remember
where. (I gotta learn to write this stuff down.)
When I have more than one workbook open, and change the window, I'm getting
a "power-point" like effect where the new window seems to be expanding from
the lower left corner of the screen to upper right. I have some of the
workbooks protected, but structure only, not...
|
1 |
28.09.2006 12:35:02 |
|
|
Can you alphabitize a column automatically in Excel?
I have a document with about 1500 names and address and I need to alphabitize
it is there a quicker way than sitting and doing it manually?...
|
2 |
28.09.2006 12:27:02 |
|
|
Not possible to save as xml
Hi
We have an odd problem here.
Almost all users in the network can save exceldocuments as xml spreadsheets.
But for some users the option save as type "xml spreadsheet(*.xml) is
missing in the listbox when opening the save as dialog.
We have tested to reinstall the officeapp but the problem remains.
If a user A that can save as xml log on to the computer of user B that
cannot save...
|
1 |
28.09.2006 12:09:53 |
|
|
Re: 2006 West Coast Excel / Access User Conference
2006 West Coast Excel / Access User Conference - October 25-27, 2006
http://www.exceluserconference.com/WCEUC.html#Tentative_Schedule
Mike Alexander
Alison Balter
Dick Kusleika
Simon Murphy
Jon Peltier
Bob Umlas
The regular registration period is coming to a close on September 30th. Be
sure to register this week if you would like to get in before the late
registration period begins....
|
1 |
28.09.2006 12:08:37 |
|
|
physical inventory sampling
I need an excel formaula that gives me the sample size required to verifify
the accuracy of our total inventory at a 95% confidence level. In other
words, if I check 'x' parts out of 2000 parts, and find these parts are 95%
accurate, can I make this assumption about the rest of the inventory? We
would like to get to the point that we annually prove the accuracy of our
inventory through ...
|
1 |
28.09.2006 12:03:02 |
|
|
Hello message!
When i cut or copy an item in ms word and try to paste it i get a
Hello! message, is some kind of a joke or a virus on my machine?
Please help i do lots of copying.
...
|
1 |
28.09.2006 11:54:02 |
|
|
How can I hold every other row color on a sheet when I sort
I am trying to run a roll sheet and to help read it I made every other line
light green.
The problem comes when I sort the line color goes with the data entered so I
lose my every other line color. Is there a way around that? I have tried
the format sheet option and come up with the same problem...
|
2 |
28.09.2006 11:52:01 |
|
|
Excel Network Share problem
Hi
We have a Windows 2003 Server with SP1 installed. There is a mapped
drive
which contains a file eg filename.xls which all users can access on
their
workstations.
Recently we have started having problems when users open this workbook
and
make changes and then save back to the network share in that they are
having
problems saving this file.
On looking in the shared drive, as each...
|
1 |
28.09.2006 11:35:50 |
|
|
Excel Network Share Problem
Hi
I previously posted this here on 13 september 2006 but got no replies
We are still having the same problem and would appreciate some assistance.
If i have posted to the wrong newsgroup then my apologies and can you suggest
where this should be posted.
We have a Windows 2003 Server with SP1 installed. There is a mapped drive
which contains a file eg filename.xls which all users can...
|
1 |
28.09.2006 11:35:02 |
|
|
Open a separate Excel Program in a new window
...
|
1 |
28.09.2006 11:00:01 |
|
|
wen certain value is added to a row tht row is copied in another s
I have one master sheet and 3 minor sheets(Type, A,B,C),In the master sheet,
each row has a variable of either A,B,C. I want to be able to enter the data
once in the master sheet and then if it contains the A variable that row is
entered in the Type A sheet, and so on for all 3 variables....
|
1 |
28.09.2006 09:57:02 |
|
|
excel file dose not open
...
|
1 |
28.09.2006 09:43:01 |
|
|
ISO smallest passive / do nothing formula for formatting null..
just trying to make header lines with top / bottom lines. Problem with
conditional formatting for "not" needing any result in a formula, that might
corupt / take space.. etc. would use something like =CELL() if that were
valid.
Is there a variation on that?
else smallest / non-dependant would have cell = itself :), not what want? but:
=A1
any suggestions would help.. maybe this i...
|
1 |
28.09.2006 09:34:02 |
|
|
Create a Calendar of Projects in Excel
I need help creating a calendar of projects for more than one manager and
rolling them all into one main spreadsheet. Does anyone know how to do ...
|
1 |
28.09.2006 09:23:01 |
|
|
advanced filter
Hi
How do write criteria to exclude 3 range of codes when using advanced filter
copt to new place.
Thanks
Tina
...
|
1 |
28.09.2006 09:13:01 |
|
|
Conversion Ratio
I used the ffollowing to get the conversion ratio format I wanted
CONCATENATE(1,":",A1/B1)
Now I am trying to figure out if there is a way to show the results in
a whole number ie 1:32 instead of 1:32.6666666.
Is there a way to do that?
...
|
7 |
28.09.2006 08:59:16 |
|
|
Comparing approx values
Hi Guys,
I have a spreadsheet that has a list of names and their email addresses that
I would like to use for a mailout.
Some of the names and addresses on the spreadsheet are from competitors and
I would prefer that they didn't get the mailout.
I have a list of domains that I do not want to send the mailout to.
Is there a way in excel to compare the two lists and delete the rows t...
|
1 |
28.09.2006 08:48:01 |
|
|
Hyperlinks to .msg files
When I we create a hyperlink to a .msg document (which was created in
Windows 2000) on the network , the error message 'cannot open specified file"
is displayed.
I am using a Windows XP machine and I believe the same problem occurs for
Windows 2000 users when trying to open hyperlinks to Outlook messages from my
machine.
Do I need to convert the .msg files to another format in order...
|
8 |
28.09.2006 07:57:02 |
|
|
CountIf or Sumproduct
hi
i got a problem with function Countif and sumproblem
My problem is that i need to match 3 diff critieria , if all of them matches
, on a cell , it will count 1 .
1st spread sheet
Date Status Place
010906 Accepted L.A
010906 Accepted L.A
010906 Pending L.A
020906 Accepeted c...
|
5 |
28.09.2006 07:56:45 |
|
|
insert between 2 columns with formulas
Hello,
Is there a way to insert a column between 2 columns with formulas. As when
I try instead of inserting. one of the columns data is removed.
cheers, d...
|
2 |
28.09.2006 07:09:41 |