Conditional format if cell=0 then font colour same as background .
I have linked a cell from another sheet. If the original cell is blank, 0
shows in the linked cell (text would be typed in source cell).
To handle this, I conditionally formatted the linked cell, so if it equals
zero, the font colour is the same as the background colour of the cell so you
can't see the zero
But the zero still prints even though it is not showing prior to printing
Try the formula
in the linked cell.
to e-mail direct replace @mailintor.com with @tiscali.co.uk
"Paligap" <Paligap@discu...9.89E+09 Why this instead of a 10 digit number in cell?
When I paste (regular or special) a 10 digit number
beginning with 989, I get 9.89E+09 displayed in the actual
cell, even though the actual 10 digit number appears in
the box above that is suppose to be showing what is in the
cell. All cells involved are formatted to General, and
changing the formatting to Text leaves the same oddity.
Make the column *wider*.
Please keep all correspondence within the Group, so all may benefit!
"Tim Fitch" <firstname.lastname@example.org...returning blank cells
i know this must be simple.....but......im referencing one sheet to
another....example on sheet 2 =(sheet1!a1) ...i want the cell to be blank on
sheet 2 unless there is information on sheet 1......i know this isn't brain
surgery...but ive tried all the cell formats and nothing seems to return a
blank on sheet 2....HELP
You don't need the parenths in that formula:
You could use this to return a formula blank:
OR, use this custom format to suppress the display of 0's:
OR, goto Tools>O...Hotkey problem w/ macro to append comment
I have a macro that opens a comment box for appending. The problem is that
it only works when executed via the Tools, Macro, etc. sequence. If a hotkey
is assigned and used to execute, the macro only adds a blank comment if no
comment existed - but even this isn't open when the macro terminates. I am
using SendKeys "%ie%" to open the comment (and leave it open). Any ideas why
this won't work with a hot key (but does via the toolbar sequence) or
suggestions for another way to accomplish this same thing?
I don't know the technical reasons why it doesn't work-...Change measurements from inches to centimeters in EXCEL 2002?
I want to see measurements for margins for Page Setup in both Centimeters and
Inches - how do I change the display? (EXCEL 2002)
...Customer Name change
What would be the repercussion of changing the customer name in the rm00101
On Aug 4, 6:53=A0am, TBrooks <TBro...@discussions.microsoft.com> wrote:
> What would be the repercussion of changing the customer name in the rm001=
rm00101 is a Dynamics GP table. This is a Dynamics CRM forum
(different product). Given you're not changing the ID, I think you can
get away with it but I'd ask in a GP forum to be sure.
Want to hear me talk about all things CRM? Check out my blog
or hear me tweet @leontribe
I agree with ...Help with Fonts
I have a document created in MS Word 2002 version. When I am looking at the
font of this document some words have been highlighted as Arial pt 10 all
caps while other words which are also in capitals are only highlighted as
Arial pt 10. Any idea why only some of the words are highlighted differently?
Also any idea how we can avoid this from happening? Any help will be greatly
All Caps is a font property (like Bold or Italic); when it is removed, the
underlying text (in lowercase or Caps & lowercase) will be restored. If the
text has been typed in capitals (usin...locking cells #4
is there anyway i can lock a cell so it cant be changed, someone please help
1. Select the cell(s) you want to lock.
2. Click Format --> Cells and choose the 'Protection' Tab
3. Ensure that the check box for 'Locked' is ticked.
4. Click Tools --> Protection --> Protect Sheet.
5. Select the properties you want to lock for, and supply an optional
Now when you try to change the cell you will be presented with a message
informing you that the cell is locked.
To remove the protection click Tools --> Protection --> Unprotect sheet and
...sequencial cell numbers w/ an Exception
Ok I read the previous post about sequencial numbers but how can I set
up the numbering so that it all ways add the contents of the previous
cell, regardless of what the cell name is.
I use the normal process for creating sequential numbers but when I
insert a new row w/i the group the sequence is broken.
Is there a way to say
A1 = 5.0
B1 = SUM(PREVCELL + 5);
C1 = SUM(PREVCELL + 5);
A1 = 5.0
B1 = SUM(A1 + 5);
C1 = SUM(B1 + 5);
As you can see that if a new cell is inserted into the later it breaks
but the earlier statment still holds true.
Thanks in advance
Sharr...font size in dialog
While I was developing my MFC APP, I changed my windows font from 96
dpi to 115 dpi. And I found that in two of my boxes the size of the
text and some control (like picture) are differents. How can I make
them the same? Do I need to redesign my dialog?
Pictures are typically measured in absolute pixels, while controls are
measured in units based on the current system font (that much you have
If I run in a high resolution, it might be for two different reasons:
1. I want to be able to see more windows on screen. Dialogboxes will be, in
absolute measures, ...Help: How to make the line changes default
I am using 2010 beta. How do I made my line changes the default
for a style? I want to use a thick red line to underline passages
and keep it that way always.
Don't have the beta here right now but I think you can set the line and then
right click > set line default
john ATSIGN PPTAlchemy.co.uk
Free PPT Hints, Tips and Tutorials
> I am using 2010 beta. How do I made my line changes the default
> for a style? I want to use a thick red line t...Custom Cell Format #2
I would appreciate any help with the following problem:
I am using XP OS and Excel 2002.
I need to enter a series of numbers (which are really text since no
calculation will be needed). For instance I might need to add the
I created a custom format cell of 0000"-"0000"-"0000"-"0000
When I enter 4000500249111567 it displays 4000-5002-4911-1560 . The
custom format appears to be rounding all my last digits to zero.
Thanks in advance, for any help.
That is because you are coming up against Excel precision limits, 15 ...Font available in PowerPoint only
Operating System: Mac OS X 10.5 (Leopard)
I've got a strange problem that I've been living with since Office 08 was released. I have one font that is available in every program on my Mac except for Office.
The strange thing is that if I open a PowerPoint file that was created on another computer with this font in it, it will show up in PowerPoint. This quirk does not apply to Word or Excel, and I do not use Entourage.
I've looked all over and the standard font problem solutions have no effect in this case - believe me I've tried.
...BdStart.xls is locked for editing
This is driving me nuts! I have run into this problem more
times than I can count. Does anyone know what it is I am
doing wrong or what to do to fix the problem.
"BdStart.xls is locked for editing" message appears in
every excel file I open. Please help! Thank you so much.
Several Posts about this back a year or two. Can be found at Google.
One Poster said he could rename it.
Try to delete from the XLSTART folder or move it out.
You might have to go into DOS to delete it.
None of the ...Urgent : Duration getting automatically changed
I have tasks with task type as fixed duration.
While importing data for assignments for that task I notice that the
DURATION gets AUTOMATICALLY changed in 2 cases:-
1) When I am importing actual effort for assignment
2) When I import actual start date for that assignment( assignment doesn't
have actual finish date as of now).
I am not able to find the logic why MSP is doing that.
Any help or insight into the behavior is really appreciated!!
Thanks a lot in advance!!!
You may see duration getting changed if you moved the ta...shortcut/hotkey-problem
I have set a custom hotkey to a shortcut/program on my Windows XP Start Menu
(CTRL-ALT-B). However, this programlink was deleted. If I now try to
reassign this shortcut, it does not work - it seems that the combination has
been still reserved for a non-existing link. Is it possible to unmap the
combination to map it then again?
Hopefully someone can help me.
Thank you, Johannes
Perhaps the info in this thread will help.
johannes pfeffer wrote:
> Hello NG,
...Simple DDX_Text with edit box and spin button falls over
I've run across something I've never encountered before, though I've
used spin buttons many times in the past. I've reduced it to a bare
minimum program as follows.
-Create an MFC dialog app
-Add two edit boxes and two spin buttons, one for each box (in the
-Add integer variables to each edit box
-Set the spin buttons to autobuddy the edit boxes and to setbuddyint
-Create OnChangeEdit() methods for each edit box
-Inside the methods, call UpdateData( false ) to read the edit box
On the generated call to DDX_Text for the second edit box
( DDX_Text(pDX, ...HotKey Questions
I was curious if there was a hotkey that would execute a query in access
2003, and one that would toggle back to the sql editor? I ask this because I
have a lot of testing to do and the extra clicking is becoming tedious...
I can use Alt + V + Q to switch a query from design view to SQL view and Alt
+ V + S to switch it to datasheet view.
I use Alt + D to open a query in design view from the database window.
"notyelf" <email@example.com> wrote in message
I have tried numerous times to change the sounds in Microsoft Money...both
within the Money program itself...and, through the Control Panel..
BUT, EACH TIME I SAVE THE NEW SCHEME AS "MY SOUNDS", THE CHANGES I MAKE ARE
NEVER SAVED....AS IF I DID NOTHING!!!!!!
Can anyone please help...my changing sound events in microsoft money never
seem to remain as changed.
Have you looked in Control Panel>Sounds and Audio Devices>Sounds>Sound
Schemes? There maybe an entry MS Money there. If yes select it and click
&qu...VBA: Column Select then Data Select then return to cell A1
How do you write in VBA:-
to select a column then select the range of data held in the column (say B1)
then return to Cell a1. The data in the column can change in the workbook as
it is updated regulary, so the range of data in the column varies constantly.
There are column headings so the range in column B1 must start at B2.
It's not entirely clear what you want but maybe this which copies the used
range of column B and pastes it into A2
Dim LastRow As Long
Set sHt = Sheets("Sheet1")'Change to suit
LastRow = sH...changing exchange organizations
What is the best method for changing the organization to which an exchange
2000 server is in?
I do not believe there is any way to really do this...what is your
objective? The "move server" wizard can be used to move a server to a
different site, but I don't think it can be used to move to a different
"Mike" <Mike@discussions.microsoft.com> wrote in message
> What is the best method for changing the organization to which an exchange
> 2000 server is in?
We have an exchange 2000 server i...publisher-how do you change font color in word art
publisher-how do you change font color in word art?
Select the word art object.
On the word art tool bar, select "format word art" which is the button that
looks like a paint can pouring paint onto a brush
Click the "colors and lines tab
"Donna" <Donna@discussions.microsoft.com> wrote in message
> publisher-how do you change font color in word art?
...Macro to goto specific cell (todays date)
i have a sheet set up as follows
A B C
1 John Andrew Steve
this sheet goes up to the end of the year 12-31-2010
what i am looking for is a macro that when upon opening the document brings
the user to the row corisponding to the current days date.
Rows(Date - DateSerial(2010, 1, 1) + 2).Activate
...Right Click to Autofill cells in 2003
In 97 to 2002 it was possible to right click when using Autofill to copy the
cells down rather than continuing the sequence. in 2003 i just get a pretty
red line (what purpose does this serve?). Does anyone know if I can get
back the old functionality?
I have that functionality in Excel 2003 as well, maybe you have installed an
add-in? In any case if you hold down ctrl while using the left click copy
down it will also copy as opposed to fill a series
> Hello All,
> In 97 to 2002 it was possi...Font schemes ... again : )
I was without internet access for a long time (grrr!) and my last post got
a bit lost I think. I was just wondering if anyone knew the answer to this:
Thanks so much everybody for being so patient!!!
Thanks for your reply (sorry about my delay - no internet access, aaagh!).
Absolutely agree with you re making changes after the fact - very tricky for
a dopey publisher user like me.
I think I have to do it that way though, as I am trying to make six
different versions of the same 150 page document (with no linked text boxes)
in different fonts (in Australia, we have a di...