Making cell change colour
I want to make a cell change colour 'on click'.
Is there any way that this is possible?
Help would be appreciated,
Message posted from http://www.ExcelForum.com/
this would require VBA / using an event procedure like
Selection_change. Do you want to go this way?
> Hi all
> I want to make a cell change colour 'on click'.
> Is there any way that this is possible?
> Help would be appreciated,
> Many thank
> Message posted f...Read receipt problems #2
I'm using Outlook 2003 with 3 seperate email accounts, one of these accounts
being my business account. How do I set up Outlook so that when using my
business email address Outlook asks for a read receipt but not when using my
personal email address? I have managed to set Outlook up to ask for a
receipt ok but it asks for a receipt no matter which account i use.
Simon <si@com> wrote:
> I'm using Outlook 2003 with 3 seperate email accounts, one of these
> accounts being my business account. How do I set up Outlook so that
> when using my business email...Wierd CRM Problem
I am running CRM 3.0 SBE on SBS 2003 Premium. I have 17 CRM CAL's and
10 Server CAL's. I have 3 names users setup in CRM. Everything
worked perfect when I was the only one logging in doing the
customizations. I gave another person access to the system for
testing purposes. Since then I lose access intermittently. I access
through IE 7 and the server comes back as cannot find server.
If I access the crm server via IP (192.168.1.XXX:5555), it prompts me
for the login. I enter the information and when the first window
closes the second window never comes up. If I then go to http:/...Pasting a cells format problem
If I cut and special paste a cells format from a previous
spreadsheet to a new spreadsheet I loose the ability to
have the "Format Cells..." menu popup. either by right
clicking on the cell and selecting "Format Cell .." or
from the tool menu "Format\Cell..." The worksheet is not
protected and there is no conditional formatting for the
cell. How can I regain the ability to format this cell?
...%s in Accounting Format
I am using Excel 2007.
I want to have a column that lists percentages - but to still be able
to use the accounting single underline correctly. When I manipulate
the accounting format to _(*#,##0.00%_) the underlining is not
correct. If I use the accounting format I cannot get "%" signs.
Does this work?
_(* 0.00%_);_(* (0.00%)
"jadeB" <email@example.com> wrote in message
>I am using Excel 2007.
> I want to have a column that lists percen...SMTP Problem
I am having a problem sending email out through my school's SMTP server. The
error message is this:
Your message did not reach some or all of the intended recipients.
Subject: Test chapman out
Sent: 9/15/2004 8:07 PM
The following recipient(s) could not be reached:
'firstname.lastname@example.org' on 9/15/2004 8:07 PM
504 <timk>: Helo command rejected: need fully-qualified hostname
My machine name is TIMK. Apparently, when outlooks sends the HELO command,
it just uses the machine name and not a FQDN. Is there a way to force
outlook to do this? How? Thanks!
No, you can'...How to change date from US to UK format
I have a large-ish spreadsheet (4000 entries) with a date of birt
column. For some reason when this file was ported from SPSS into Excel
before being sent to me, the dates of birth got a bit screwed up.
ABout a third of them are in the format I want. UK format wit
day-month-year. The rest are in US format with the month first. At th
moment I'm having to just go through them and type or copy hem into
new column. Its essential I have the whole column in UK format.
Is there any formulas that can do this for me to save me typing it al
out?!! Any help would be MUCH appreciated!!
...Outlook 2002--How do I change account which email account is active?
I have a problem with a Outlook 2002 that makes me think the active
account is corrupt. Each time I try to log onto ISP to get email,
Outlook prompts me for the password. I have set the password through
Windows software and when I log on thru Outlook, I keep checking the
box to "remember password" but it doesn't. Now I'm getting connection
errors that are not consistent and if I ignore them, I can still log
on. This all makes me think maybe the account I'm using has become
corrupt. How can I copy my User Files and then create a new account so
I can delete the present acco...Changing from Balance Forward customer to Open Item
Recently one of our affiliates imported their customers from their old
accounting system. Unfortunately, the balance type flag was set to balance
forward rather than open item. This was not discovered until significant
activity had been keyed so they don't want to re-load and re-do several
weeks' work. Is there any way to change a customer, with posted activity, to
In the RM_Customer_MSTR table: RM00101
Balance Type: Integer. Field values:
0. Open Item
1. Balance Forward
In SBM, this field is always set to a value of 1. This field is...Complicated Formula Problem #3
Thanks Mark...I've sent you the file
I am a Technology Specialist and District WebMaster for a schoo
district in Texas
Llobid's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=777
View this thread: http://www.excelforum.com/showthread.php?threadid=27647
...why does currency format change to number format?
every time I format a column in the currency format and save, when I go back
to that column, the formatting has changed to number format. How can I get
this format to stay?
Are you actually closing and reopening your file?
If you are, how are you saving your workbook--as a .xls ("Microsoft Office Excel
It kind of sounds like you're saving as a .csv (comma separated values) file.
This type of file is plain text and won't preserve the formatting when you
> every time I format a column in the currency format and save...cell format update problem
c1, c2 is formatted as text.
and a1,a2,b1, b2 are formatted as general.
a1=1,a2=2, b1=1, b2 =2
and I entered c1 =a1+b1,
c1 shows =a1+a2 as it is, not 3.
I drag the corner of c1 and copy c1 to c2,
c2 is a2+b2,
So I have to F2 and enter all the cells, c1, c2.
Is there a way other than "F2" and "Enter"?
*Don't* format C1 to Text.
Leave it General, or format to Number.
Please keep all correspondence within the Group, so all may benefit!
"...Fill blank cells
How can I automatically fill blank cells with placeholders?
Select your range.
Type your placeholder value and hit ctrl-enter.
Debra Dalgleish explains a variation of this (with pictures!) at:
> How can I automatically fill blank cells with placeholders?
Thanks, it worked great.
"Dave Peterson" wrote:
> Select your range.
> Type your placeholder value and hit ctrl-enter.
> Debra Dalgleish explains a variation o...Problems with Partnersource/Customersource
Trying to download the new FRx service pack and manager does not seem to
respond. I am having no difficulty downloading using the manager off MSDN or
MCT sites. Anyone else experiencing this?
...auto color blank cells ,best solution
i would like to automatically color all blank cells unfilled which can vary
on each sheet at close of workbook,any suggestions .The total number of blank
cells will be no more than 100
Maybe you're looking for something like this. It works for cells A1:J4 on
Sheet 1, but you can change that as required:
For rwIndex = 1 To 4
For colIndex = 1 To 10
With Worksheets("Sheet1").Cells(rwIndex, colIndex)
If .Value = "" Then
With Selection...MS money 2003 password problem
I saw threads that indicated that lots of folks have had problems w/passwords
while using money software... I just re-loaded 2003, and it's asking for a
password when we have never used a password before when we created the file
w/2003 money. And - like so many others, it won't accept the password that
is for our hotmail... what's up w/that?
In microsoft.public.money, rowdog wrote:
>I saw threads that indicated that lots of folks have had problems w/passwords
>while using money software... I just re-loaded 2003, and it's asking for a
>password when we have ...Subtotal Problem
I have imported data from a golf software program listing three rounds of
golf for individuals. I want to subtotal their scores based upon a team
within the tournament. When I try the subtotal command Excel separates the
team members but returns "0" for the subtotal. I was told that Excel does
not recognize the content of the cells and I must multiply their value by
"1" and do a special paste command . . . I forgot how to do that. Also, is
this a problem with the golf software, data transfer, or something else?
I don't know about golf software, but w...Formatting long numbers accurately
I am working with credit card #s. As soon as I take out
(Using Replace) the dashes, the last digit becomes a
zero! I've tried everything, it's urgent.
example: 1234-5476-7894-1236 to 1234547678941236
Format as text
"EMR" <email@example.com> wrote in message
> I am working with credit card #s. As soon as I take out
> (Using Replace) the dashes, the last digit becomes a
> zero! I've tried everything, it's urgent.
> example: 1234-5476-7894-1236 to 123454...Problem with blank messages
About 2-3 weeks ago I received my first blank message.
i.e. a message with no sender, no subject and no body.
I carefully deleted it without much thought.
Over the next two weeks I received more an more, starting with a trickle of
one-or-two a day and escaleting to betwen 30 and 50 blank messages each day.
I'm worried that they are carrying viruses, trojans, bots or the like. I've
run a full virus check with my F-Prot, and tested with Adaware, and SpyBot.
No suspicious files have been revealed.
I'm working on a running Outlook 2003 (11.8010.6568) SP2.
My Toshiba Sa...brainteaser: change a value by 90 (but answer must lie between 0-180 )
Please see below ( I want to do step 3 - change a value by 90 degrees)
but the answer has to be between 0 and 180
e=2Eg. 45 becomes 90
e=2Eg. 95 becomes 185 (but this is wrong, so SUBTRACT 90 instead) anwer
Minus Cylinder or Plus Cylinder
Spectacle prescriptions can be written in two value sets, minus
cylinder or plus cylinder, which are mutually exclusive of each other
but provide the same information. As a rule, ophthalmologists write
script...Photo email problem in non-beta version
The last time I successfully tested the photo email option in the current
WLM (not the beta) was June 10th. A question about it recently came up in
the Windows 7 Forums that points out it may now be broken. So I tested it
again and indeed verified it is broken. At least for the both of us:
http://www.sevenforums.com/browsers-mail/99858-sending-pictures.html . So
it must have broken sometime after June 10th. I updated to the latest
non-beta version (14.0.8117.0416) on June 20th so that may be the problem.
Can anyone with the latest non-beta version let us know if you have the same...CPropertySheet Problem
I have created a NON-MODULE CPropertySheet in a form. And I have added
several CPropertyPage to the sheet.
There's a runtime error where I call SetWindowText of CProertyPage which is
not the first one. I was told that the page is not a window (hWnd = NULL).
Only the first page can use SetWindowText.
How can I change the tab name of the pages at rumtime? BTW, I can set the
captions of the pages in design time.
And I was failed to get the tab pointer by calling GetTabCtrl.
page1.m_psp.dwFlags |= PSP_USETITLE;
page1.m_psp.pszTitle = &quo...Sound problems
Config: IE8, XP Pro service pack 3, separate audio card. Audio is working
fine with several applications but NOT with IE (although audio on web pages
is enabled). It has been working earlier though. Should I uninstall IE and
reinstall it or is there another remedy?
Do you have a link to a web page where this is occurring?
You could have pressed the mute button on the Flash video you are trying to
watch and the site is retaining your preferences as you view other 'videos'.
Here is a link to a test page that will help you diagnose sound issues with ...Autofill problem
Hi, any help gratefully recieved.
If I write a formula then fill down I get the same answer in every
cell. Typing in manually the excat same formula gives me the correct
The formulae are exactly the same whether filled or put in manually. Is
this a known glitch?
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
You've left this to guesswork. Tell us the original formula, and what the
fill actually produces (formula, not result). Look...Automatically copy cells from two week day sheets based from today
I have a schedule workbook with the days of the week listed as sheets,
Mon->Sun. I want to have another sheet that displays half of today’s schedule
and half of tomorrow’s schedule but it will change day to day depending on
today. I need it to automatically copy the info so I am not constantly
cutting and pasting or making seven new pages.