Gantt Chart in Excel. Do I need conditional formatting?
I have created a Gantt chart that shows approx. 15 tasks in each project. I
am using this to show percentage of completion for each task.
It is working just fine and looks great but I need it to insert a date when
a task is at 100% completion to show the client the date that particular task
was completed. How would I do this without ruining my chart I already have
working fine? I know this is probably easy to do but I cannot seem to keep
the rest of the chart intact. Is conditional formatting the answer?
You could use Rob Bovey's XY Chart Labeler to do this:
h...Sum formula is not adding up properly
I am summing up hours in Excel and the sum formula is not working Properly.
For 2 of my 5 cells are adding correctly, but the other 2 when added to the
formula throw the entire thing off.
They are all formatted the same in 13:33 format to measure the # of hours
spent on an activity.
What would the reason be that two of them are not working? (it is almost
like exel is substracting hours when these 2 cells are added)
No real problem. Your math is probably fine; formatting needs fixing.
Select the cell with the sum in it.
Format this cell as Time 37:30:55
&quo...Excel 2003 VB referencing #N/A not working but works in Excel 2007
I have a very simple macro that works in Excel 2007 but hangs up constantly
in Excel 2003. Does anyone have a work around?
When referencing cells that have a #N/A value, Excel 2003 craps out even if
I use the ISNA application function before it. The following 2 statements
will cause Excel 2003 VB to stop regardless of order if the cell that is
referenced comes up with #N/A.
Series = Cells(RowNumStart + X - 1, SeriesCol).Value
If WorksheetFunction.IsNA(Cells(RowNumStart + X - 1, ColNum)) Then
Further background.... I am actually wanting to find #...excel formula problem #3
i want to set up a system that counts a series of dates but only say
how many cells are filled, i can get this to work generally but
section needs to count 3 seperate dates but only add on any one of the
(eg) cell A counts the number of dates in cells B-Z but with cells D,E,
i dont want all to count, only one of the three even if all are filled
but it must count if any of the three are filled hope this makes sens
Message posted from http://www.ExcelForum.com
> i want to set up a system that c...How do I convert .txt files into .xls in order to be able to sum.
I receive via e-mail a statement that I need to resort by date , purchase
order and total by department, etc. The process I have been using is to copy
and paste into Excel. However, when I try to sum the $ is will not sum.
Is there some other way of converting this statement that I receive via
e-mail into Excel, so that I can resort and sum?
I am using Excel 2002 and my e-mail browser is Mozilla.
You might be able to use File-->Open, and then let the Text Import Wizard
help. Otherwise, you could use the "data isn't recognized" fix here:
http://www.officearticles.co...SP2 screws Excel. Now only puts in decimal numbers
I installed SP2 for office 2003 yesterday and now anything I type into my
excel workbook shows up with .45 instead of 45 which I typed in.. Any ideas?
Tools -> Options -> Edit tab.
Uncheck "Fixed Decimal Places"
"Tboz" <Tboz@discussions.microsoft.com> skrev i melding
>I installed SP2 for office 2003 yesterday and now anything I type into my
> excel workbook shows up with .45 instead of 45 which I typed in.. Any
tools>options>calculation>precision as displ...Transposing Excel Formula
I have the following formula to calculate the probability of an option
trading below price B3
Prob = =NORMSDIST((LN(B3/B2))/((B4/100)*SQRT(B5/365)))
B3 = Target Price
B2 = Stock Price
B4 = Implied Volatility
B5 = Days to Expiration
I want to transpose the formula to solve for B3, assuming a value for
Here's what I got, but it doesn't give the expected answer - did I
make a mistake in these unfamiliar functions?:
On Feb 7, 10:14=A0am, Steveal <steve_alm...@yahoo.com> wrote:
> I have the following formula to calculat...Excel VBA
I have created a custom menu bar..a section of the code below...but d
not know how to create a 2nd level to look like the example below.
Current Year (action)
Any suggestions. Thanks.
' Add a new menu
Set NewMenu = NewMenuBar.Controls.Add _
NewMenu.Caption = "&Period"
' Add a new menu item
Set NewItem = NewMenu.Controls.Add(Type:=msoControlButton)
.Caption = "&By Month"
.OnAction = "Main"
Message posted from http://www.ExcelForum.com
You should find your answer here (...How do I change the format of how my active cell in Excel is view.
I sometimes have trouble locating which cell is active in my Excel worksheet.
I would like to be able to change it to something other than just a heavy
Here is one way that highlights the row and column of the activecell.
Private Sub WorkSheet_SelectionChange(ByVal Target As Range)
.FormatConditions.Add Type:=xlExpression, Formula1:="TRUE"
.FormatConditions(1).Interior.ColorIndex = 35
.FormatConditions.Add T...Excel Worksheet menu bars customizing for limiting users to optio.
Customizing Excel worksheet menu bar for limiting users to the options
provided in that menu
Look also at the links to MS pages on the bottom of this page
Regards Ron de Bruin
"jim" <firstname.lastname@example.org> wrote in message news:F8009001-5F5A-4415-9527-34C71D8DF1DB@microsoft.com...
> Customizing Excel worksheet menu bar for limiting users to the options
> provided in that menu
...EXCEL 2003 #8
Can I take the contents ("WD4") of a cell (A2)on Sheet1, look for a match of
the code ("WD4") on Sheet2 in cells A1-A20, and return the coresponding text
in B1-B20 on Sheet2 to cell B2 on Sheet1.
Microsoft MVP - Excel
"Mike" <Mike@discussions.microsoft.com> wrote in message
> Can I take the contents ("WD4") of a cell (A2)on Sheet1, look for a match
> the code ("WD4") on Sheet2 i...CONVERT TIME & TRIM DATE
I need help converting time to an AM/PM time format
our database displays time in 4 digits : 0006, 0737, 1217, 2149. I am
finding that 0006 is 12:06 AM and 1217 is 12:17 PM, etc.
The date displays: 2007-03-09 00:00:00.000, how do I have it display the date
Specify the display format of the control or field: mm-dd-yyyy
>I need help converting time to an AM/PM time format
>our database displays time in 4 digits : 0006, 0737, 1217, 2149. I am
>finding that 0006 is 12:06 AM and 1217 is 12:17 PM, etc.
>The date displays: 2007-03-09 00:00:00.0...Can you use the old Lotus "/ commands" in Excel 2003?
In Excel 2000 you could use a demo mode to activate the old Lotus menu
commands. Can you do this in Excel 2003?
Look at Tools>Option>Transition
"DAW" <DAW@discussions.microsoft.com> wrote in message
> In Excel 2000 you could use a demo mode to activate the old Lotus menu
> commands. Can you do this in Excel 2003?
It's gone from xl2003.
> In Excel 2000 you could use a demo mode to activate the old Lotus menu
> commands. Can you do thi...create automatic response to questions in excel....
Is there a way in excel where I have 10 questions and can click on one
question and get the answer to pop up in my spreadsheet?
On Dec 1, 6:39 am, felicia <feli...@discussions.microsoft.com> wrote:
> Is there a way in excel where I have 10 questions and can click on one
> question and get the answer to pop up in my spreadsheet?
> thank you,
One way, with questions in A1:A10 and corresponding correct answers in
A1:A10 on a hidden worksheet with tab name "Answers"...
right click the tab of the sheet with the qu...percent formula
How do I write a formula that gives me the total after deducting %.
Example if I have $25 and I need to deduct 14% and I need to show the total
would be 21.50
A1 = 25
B1 = 14%
Format as General or Number
Microsoft Excel MVP
"israel" <email@example.com> wrote in message
> Anyone please!
> How do I write a formula that gives me the total after deducting %.
> Example if I have $25 and I need to deduct 14% and I...What does the $ symbol mean in a formula?
What does the $ symbol mean in a formula?
The $ is used for absolut referencing. For e.g lets take your formula
suppose you enter this formula in cell B2, now simply copy this formula one
cell to the right (C2) by and one cell down (B3).
So you see that The original G8 has changed, whereas $A$1 remains the same
in both the new formulae because of the dollar signs.
"S" <S@discussions.microsoft.com> wrote in message
news:D86597A4-C0A1-46AF-9DA6-FE06AB9C1FA0@mi...Determine if another cell is hidden in a Formula
I would like to display a special message in a cell when another cell
is hidden. Is it possible?
Something like (in cell A2):
=If(IsHidden(A1), A1, "")
I guess I could do it with a user function... but if I use that in a
lot of cells (hundreds) it might significantly slow down the refresh
Any thoughts ?
...Does anyone have a formula to calculate the car lease payments
I am just looking for a formula that will allow me to calculate the monthly
repayments for a car lease. Thanks in advance
The PMT function may help you out. Look at Excels help for details regarding
its arguments and use.
"Captain Jack" wrote:
> I am just looking for a formula that will allow me to calculate the monthly
> repayments for a car lease. Thanks in advance
see if this helps
"Captain Jack" <Captain Jack@discussions.microsoft.com> wrote in message
...How do I rotate a worksheet in Excel?
I know that it is possible to rotate content within a cell, but what if I
want to rotate the whole worksheet?
And yes, I know that I could just set it to landscape mode, but I want to
modify it once the rows become columns and the columns become rows.
You are limited to 256 columns (and therefore 256 rows).
create a new worksheet
Select your range on the original worksheet
go to A1 of the new worksheet
edit|paste special|check transpose.
> I know that it is possible to rotate content within a cell, but what if I
> want to rotate the whole w...Is it possible to merge workbooks in excel?
I am currently working on a project with a coworker in which we need to enter
quality scores for employees into excel workbooks, with one sheet per group
of employees. Is it possible, if we enter data for separate groups, to later
merge this data into one master workbook?
Are you asking if you can move/copy your sheet for Group AAA into another
workbook that has a sheet for Group BBB?
If so, all you need to do is:
1) open both the source and destination workbooks
2) activate the source workbook
3) select any and all tabs that you want in the destination workbook
(Ctrl-click on ...Conditional formatting of text
Greetings, all -
I am creating a simple spreadsheet template to be distributed to users
for data entry purposes. The first column contains the names of the
desired data elements. The second column contains the definition for
each data element. The definitions are formatted in red text. I intend
for the user to remove the definition and replace it with the proper
information for each element. For example:
Data Element Definition
1.0 LastName The last name of the person to whom questions
about the sample should be directed.
The user would replace ...fonts are changing and text disappears
when i open outlook 2003 all my maps on the left side of the screen are
looking well and normal. But after a wile the font changed or a piece of the
name/text disappear. Very stange i think. When i close outlook and turn it
back on, everyting is back to normal but not for long.
...TEXT STATUS -VS- Numbers
We have name of projects with 8 different status. We want to create a chart
with the name of the project on the X axis and text status on the Y axis.
Can this be done and if so how. Please help
If you assign numbers 1-8 for each status, you can then hide the 1-8
axis labels, and add custom ones:
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
> We have name of projects with 8 different status. We want to cre...resize all rows in the spreadsheet to fit the text?
I have an existing spreadsheet created by another user.
Some of the rows are not automatically sized to display all text.
Is there a command to resize all rows in the spreadsheet to fit the
email: softwaretest underscore 2003 at hotmail
Church lady, try Ctrl a, to select the whole sheet, then format, row,
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
"the church lady" <firstname.lastname@example.org&g...how do I add a 'web address' to a cell in excel with a hyperlink?
how do I add a 'web address' to a cell in excel with a hyperlink? I am a new
student to computers, and part of a test is to insert a hyperlink to a cell
in excel linking to a web address. I have searched computer for any
'Hyperlink' connection words, but I think it not on here, Is that possible,
although I have top of range computer. Anyone with a solution? I be ever so
ctrl+k>in the link to select existing web page>either type in (at the
bottom) or point to the url on your browser>enter