|
|
|
calculate 18 monts from a date
Sun, 17 Aug 2008 09:59:00 -0700
Hi I need to calculate from une date if 18 monts has past, if is false put a
"X" on if is true livet in blank (no 0 )
ex
Kevin start on 06 mai 2007 still no 18 monts = "X"
Tony start on 03 fev 2007 hi pas 18 monts = " "
tanks ...
|
Cell protection ?
Sun, 17 Aug 2008 16:58:18 +0100
Hi,
When a formula is entered into a cell is there a way to protect that
cell so the formula cannot be removed?
Appreciate your assistance ...
|
Re: Drop Down List
Sun, 17 Aug 2008 07:09:41 -0700 (PDT)
On 5 Aug, 17:46, Pete <fell-wal...@hotmail.co.uk> wrote:
> On 1 Aug, 22:59, Gord Dibben <gorddibbATshawDOTca> wrote:
>
>
>
>
>
> > I think this is it.
>
> > Tested on both the DV drowdown selection and the multiply by Offset(6, 0)
> > codition.
>
> > Private Sub Worksheet_Change(ByVal Target As Range)
> ...
|
Password for rows and columns
Sun, 17 Aug 2008 06:56:00 -0700
Is there a way to hide a row & column with a password in a worksheet, in such
a way that the other user should be able to work on the same worksheet but
with the remaining rows & columns, without being able to open the hidden row
& column ...
|
Need help with Macro's and Shading
Sun, 17 Aug 2008 00:47:01 -0700
Sorry If I'm posting in the wrong place.
I'm trying to set up some shading macro's or rules for an excel page (excel
2003) and running into a little difficulty. I set up a macro to put in a
light shading to make everything easy on the eyes every even number row:
Range( _
"A8:S8,[through],A94:S94" _ ...
|
Sumproduct & nagetive time
Sat, 16 Aug 2008 08:48:02 -0700
So far I found I can use this, in column E.
=IF(C3<=D3,"+ ","- ")&TEXT(MAX(C3,D3)-MIN(C3,D3),"[m]:ss")
To display negative time, whereas before I was using,
=IF(D3="","",D3-C3) to leave the column E blank.
The 2nd one was good because it would leave the column blank until I made an
entry in D, is ther ...
|
SLOW FUNCTIONS
Fri, 15 Aug 2008 10:40:34 -0700
Dear Experts,
I have a 'new" excel 2007 & need to run in compatability mode because most
of my associates have 2003.
Almost all functions - from cut and paste or copy and paste are delayed
while the little blue circle thing spins. Usually form 4 to 10 seconds. it
really adds up. What can I do to cor ...
|
|
|
#N/A error messages
Fri, 15 Aug 2008 05:42:01 -0700
I am trying to sum a colume that has some cells with '#N/A'. The cell with
the total, displays a '#N/A' now. How can I have that cell display the total
of the numbers entered when there are the errors in the sumed cells. Thanks. ...
|
Possiblity of Two X Axis Graph
Thu, 14 Aug 2008 15:02:08 -0700
I need to compare 2008 sales against 2009 sales side by side in asingle graph.
My data is given below
PERIOD-09 Jan 09 Feb 09 Mar 09 Apr 09
SALES-09 2500 2550 2230 3100
PERIOD-08 Jan 08 Feb 08 Mar 08 Apr 08
SALES-08 1900 1990 2301 2900
Any solution?
Fowmy ...
|
customizing text color
Thu, 14 Aug 2008 11:25:01 -0700
would it be possible to assign color for a certain letter in a cell
content?e.g all the content of the cell in my worksheet consist of either of
these 4 letters only ( A , P , N , O).can it be that if i type A it would be
in color Blue,and if i type P it would be Green,etc.? ...
|
|
|
