make colour in rows stay
How can I lock the fill colours in a row even when I change around the data
or sort alphabetically?
Thanks and God Bless,
Regards Ron de Bruin
"Crowraine" <Crowraine@discussions.microsoft.com> wrote in message news:ED158D7D-62AB-4DA8-A948-2A6556D8047C@microsoft.com...
> How can I lock the fill colours in a row even when I change around the data
> or sort alphabetically?
> Thanks and God Bless,
...Help with conditional formatting with 2000
Any help would be greatly appreciated.
I am trying to group data together into increments of 10% of th
numbers and then chart them based on these groups. For example, I hav
300 data points that vary from 20 to 500 in value. I want them t
appear in a chart based on the number of values that fall in the lowes
10% of numbers (ie. 20-40) then the next 10% (ie. 40-60) etc. up to th
top 10% of numbers, but I do not want to manually determine what thes
ranges are. I want to see a distribution of how many numbers fal
within each 10% of values.
I am not sure if this makes sense, please let me know...Help! Setfocus problem
i ave a dropdown field on the first tab. I use setfocus so that it selects a
different field to stop users scrolling down and changing the selection on
the load event.
When a user changes tab and come back to the origional tab the setfocus
doesnt run as the form is already loaded. How do you get around this?
This is driving me and users mad at minute...please help before i open
another bottle of dark rum!
Check out following URL; how to fire onclick event on tab click. It may help
PLEASE do click on Yes or No button if this post wa...Please Help!!
I am having problems restoring a backup money file from
my cdrw disc. I recieve the error that it can't open
possibly because it is a read only file or you do not
have permission to change it or your disk drive is write
protected. I have never had this problem before. I have
restored files from my cd backup 3 times before without a
problem. Please help!!!!
Restore the file to writable media - your hard drive. If you still can't
open it, right-click on the file in its new location, choose Properties from
the context menu, and remove the check from the 'read-only' box.
-...You wont believe this! SERVER DOWN
I was helping the operations/it director to get RPC over HTTP going on their
exchange server for a company I use to be the sys admin for. The ops/it
director was doing the add/remove programs portion to add rpc over http
there, somehow in the process of doing this he managed to uninstall IIS -or-
just NNTP and SMTP (I can't figure out which and he claims he did neither).
Long story short, I've reinstalled NNTP and SMTP, reconfigured SMTP to the
best recollection I have of the previous config and the server still refuses
to send/receive email, even internally. All services are s...!!HELP!!! Cannot connect to Exchange Server from a RDP, ICA session or server local machine
Please excuse the posting as I wasn't sure which group to post this in. I'm
having issues using Outlook from a server desktop, an RDP or ICA connection.
I have remote users who connect using Citrix. They logon to the Citrix
server desktop (Windows 2003 Server) and use Outlook from there. They can
also use Outlook from within Citrix as it is a Published Application. I know
some of you are going to suggest why don't they use OWA but let's not get
into that. I can log onto any workstation here in the office and connect to
the Exchange server and open their Outlook. What I and they...How to make return address labels in Publisher?
Can you do the title above in Publisher?
Sure. I've done them in different label sizes. What size labels are you
"Robert" <Robert@discussions.microsoft.com> wrote in message
> Can you do the title above in Publisher?
Thank you. I use the 2.5" x 1" size. it is a standard Avery Label size.
"Don Schmidt" wrote:
> Sure. I've done them in different label sizes. What size labels are you
> interested in?
> Van...Internet connection problem
Hi. I hope someone is able to cast some light on a problem. We have a
home network (all computers running XP) some wired and some wireless.
For about a month now we have intermittent connection problems in that
any one computer (randomly) will not connect to internet. I think all of
the computers have suffered from the problem. Rebooting the affected
computer makes no difference but rebooting the router can sort it until
the next time. Even my mobile phone occasionally cannot connect. In
Firefox the message is just "server not found". Pinging an IP address
results in a time...I need help restoring Public Folders
I've been having issues getting Public Folder replication going between 2
Exchange 2003 servers.
Prior to doing any work I performed a Backup using Veritas Backup Exec and
this completed and verified correctly.
I screwed things up and managed to delete some of the public folders on my
original server. I'm not 100% sure what I did but it is a mess and the only
backup I have is the Exchange backup I created before doing any work.
The public folders contain a number of Contact Lists and a very important
I have restored the public folders but when the restore c...Help with Synchronizing a user folder with a Public Folder
Hoping that someone can offer a suggestion on this one.
I'd like to be able to synchronize an email folder in a particular users'
Outlook account with a public folder. The idea is to have email
conversation threads in a particular folder (just one folder) visible to
others in the group via the public folders. Ideally, it would be great if
changes to the public folder are instantly mirrored in the users folder -
but that requirement is not critical, the core requirement is to have the
public folder mirror the user's folder (in real time).
I know that I could accomplis...Need help on a formula 05-20-10
I need a formula to calculate the following information please: I will have
someone enter a time (ex 6:31) in cell C3. If the time matches one of the
times in cells B17-B22 I need it to display 4.6, if it matched one of the
times in cells B23-28 I need it to display 4.7, if it matches one of the
times in cells B29-34 I need it to display 4.8 and so on. Does anyone have a
simple formula I can do for this please?
Can't do the "and so on" part, bu...Terminal Servers in Cluster - Login/Profile Issues
Currently I am having an issue with logins and profiles as per details
Server/Network Configuration Details:
1 X Windows Server 2008 Std FE 64bit (DC)
2 X Windows Server 2008 Ent 32bit Terminal Servers
User Profiles are Roaming and exist in: \\SBSERVER\Profiles on the Domain
Controller and C:\Users\ on the Terminal Servers.
Approx 50 users.
Error messages when logging in the terminal servers: Your roaming profile is
not synchronized correctly with the server. Windows will load your
previously-saved local profile instead. See the pre...RMS 2.0 matrix dimensions are annoying, but help is available
For reasons I don't understand, MS saw fit in RMS 2.0 to use dimensions data
for matrix components that is far less accessible to users than Sub
Descriptions are. For instance, I can't edit assign a dimension value to an
existing item I have added to a matrix. I can't see a reason for using
Dimensions with limitations like this as using Sub Descs. to describe matrix
"dimensions" worked fine previously. Does anyone know why MS did this? It's
Digital Retail Solutions (DRS) has a product called Power Ops (Build
2.2.0003). It's help file mentions (se...Membership cards and discount cards
anyone know if RMS works with membership and discount cards? I would like to
offer that to my customers and have them accrue rebates. Best, M
Depends on the card and exactly what kind of membership program you want to
offer. If you create membership cards with a barcode for the customer
account number, and simply want to offer discount levels, you can get good
functionality right out of RMS. If you want to offer rewards based on
points, or use magnetic membership cards, it gets much more complicated and
you're going to need an add-in. Talk to your RMS Reseller about your needs,
...Excel Formula Help
I am setting up a basic excel spreadsheet and really have got no experience
with excel. I want to do something real basic like if A2=laptop display $10
or if A2=desktop display $20 how do I do this?
I think that if the list of options is more than a just a few, a =vlookup()
function would work nicely.
It may seem a little complex to start, but once you use it, you'll find tons of
more reasons to use it.
Debra Dalgleish has some nice instructions at:
> I am setting up a basic excel spreadsheet and really have got no...Help-- Having trouble opening Word & Entourage
I have to keep restarting my computer to be able to open Word or
Entourage. The icons just bounce a little but won't open. I was
getting a request from Entourage to rebuild the database which I did
about 6 or 7 times. I got another warning which I ignored. I am on
a MacBook Pro (Intel based). I am using office 2004. My Entourage
database is 3.2 gb. I ran Disk Utilities a couple of times. I also
had a problem a couple of times with FileMaker Pro but not sure if
On 22/8/06 20:01, in article
firstname.lastname@example.org, "...Help with a code
I have these code and it works find: but i also want to use it for
different culumn within the same sheet. how do i add Column D with
different target? meaning "S" for Study and "B" for books and s
and maybe adding a Msg box to it that will only allow the Letters
thank you in advance..
Private Sub Worksheet_Change(ByVal Target As Range)
If Target = "" Then Exit Sub
If Target.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("c6:c50")) Is Nothing Then
If UCase(Target) = "C" Then
Target = "Contribution"
El...Need Help With GP Item Pricing
GP ITEM PRICING
I need to use “Bucket Pricing” for items in GP. For example below is the
pricing schedule that I need to use.
First 20 …………….$ 1.75
Next 280 ……………… 1.36
Next 700 ……………… 1.23
Next 2,000 ……………… 1.09
Over 3,000 ……………… .82
So if I had a Qty. of 350 it would be as follows
20 * 1.75 = 35
280 * 1.36 = 380.80
50 * 1.23 = 61.50
Total : $477.30
In GP I can only set it up to do a “Quantity Range” in the Item Price List
Maintenance window. Problem is if I set it up that way and enter a quantity
of 350 it will default to the $1.23 ...Help Please in Summing
Sorry to ask such a simple question, but I need help on
how to get a total of some cells.
Here's the sample.
A1 is 05 and is true
A3 is 10 and is true
A5 is 15 and is False
A7 is 10 and is True
A9 is 05 and is False
How can I make A11 show me the result by just adding those
numbers that are TRUE and give me the sum ?
Would really like help, thank you.
I assume that you have TRUE or FALSE as boolean in an adjacent cell.
But the assumption may be wrong and you'll need to provide more
Regard...zip code help! #2
thanks for the help !!!!!!!!
cbender3's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1556
View this thread: http://www.excelforum.com/showthread.php?threadid=27126
...Error trying to make an account default
I have a new computer and my outlook 2003 is not letting
me assign a default account to send and receive. I get
this error: "The Specicied Account could not be found. It
might have been deleted."
I have four accounnts setup and have tried removing the
accounts and recreating them and still get the error.
when the account has been made, it tests fine. None of
the four can be made default.
Thanks in Advance!
...Make sales target (quota) invisible for other users
I am setting up a MS CRM system for a pilot which focus primarily on our
I have given each user who's a salesperson given a quota in the CRM system.
These numbers are confidential and so not everybody may be given the
possibility to view this data.
But when I checked with another role, I could see the quota of erverybody
who's got quota assigned.
Is there a possibility to make these quota's only visible to the persons I
want (for example the director can see the quota's of everybody, the
salespersons can only see the quota for themselves and the rest o...How do I make X-values of a chart dependent on values in cells?
I have a chart which can go from x-value 0 to x-value 200. However
I'd like to be able to input min X-value into a cell, and a max X-valu
into a cell, and the x-value in the chart changes to reflect that.
Is it possible to do that?
Thanks for any replies.
Message posted from http://www.ExcelForum.com
There is no automatic way to do this but take a look a Tushar's
AutoChart Manager for a possible solution.
Kashgarinn < wrote:
> I have a chart which can go from x-value 0 to x-value 200...Can't Make Brochures
To make a brochure, I open up Publisher, go to 'Publications for Print' ->
'Brochures'. No matter which design I select, about 5 seconds after the
'Changing your Publication' window comes up, another window pops up telling
me 'Publisher cannot complete the operation'. This only happens for brochures
- all other publications work. Does anyone have the answer?
Try a detect and repair in the Help menu. Do a disk clean-up. Don't delete the
Office setup files if you do the disk clean-up. The clean-up is found by right
clicking your hard drive, propertie...Help! I've inherited a messed up plan :
I just came onto a project and got a 1700 line project plan from the previous
4 project managers.
Q. Is it normal for tasks with unassigned ? empty resources to show that
task in the Resource Usage window?
And then on the Gantt View, when I add a resource under that column, it then
shows up on the Task line as a Task!
I've never seen this happen before. Any ideas?????? J
> Q. Is it normal for tasks with unassigned ? empty resources to show
> that task in the Resource Usage window?
Sure - it shows up under the "Unassigned" label.