I posted a question last night but see that I have one piece to finish
my spreadsheet.
Here it is...
I have a Gantt Chart that I am developing in excel.  Basically I have

Where a formula result is negative I would like a down arrow to appear,
positive and upward arrow and if zero a sideways arrow - can this be done

I have a spreadsheet with more than 45000 rows with all the projects LTD, and
only few open projects. Currently I am copying the data in different tabs,
and sorting, by project, delete the others, then copy to other tab and sort
by phase…and so on.

I run into this problem a lot, and each time I have to kludge together a
solution that seems overly complicated. Maybe someone knows of a more elegant
way?
Say I've got the following table:

Is there a way to make a worksheet name = cell?

I want to turn one cell green (f45) based on another cell (a45) having a
zero in it.
Seems simple enough, and I thought it would be as straightforward as:
=a1=0

I need help with LOOKUP or VLOOKUP.
I have two EXCEL 2000 documents ( Estimates.xls and Prices.xls).  
(this is a snapshot of ESTIMATES.xls)
      A                B               C

i am trying to creat a script than i can assign to a button, so when i click
on it a dialog box appears with which will show tha days,hours,min and
secounds left till a given date that i can adjust in the script ,,,,
I have mannaged to get one to work in lotus 123 but not sure how ...

I use excel for my quotation and when i print out the wordings is not
straight or crooked and box is also not straight can anyone help me to solve
my problem thanks

I tried to look in the sub menus to change this back to
Alphanumeric but every change I made did not take.
Any way to force Excel back to it's original settings?

I have 2 sheets. Sheet 1 has several columns including Date, Variety,
No of Stems. Sheet 2 is a pivot table based on Sheet 1 data showing
Variety and Max Date.

I am hoping to make my spreadsheet commercially available therefore I want
to  want to protect my formulae by making it invisible to prying eyes and
through auditing. I can out some in a password hidden sheet but some cells
need to appear on visible sheets. Can I somehow make the ...

Hi all...
Hoping you can help...
I'm fairly new to Excel but have been picking up bits and pieces (mainly from
this forum!!!)....

What is wrong with my formula?  Here is the formula I wrote.  I placed it in
the function field:
=SUM(IF(J2:O2=""),"",I2-(J2:O2))
Here is what I am trying to do with the formula --

Is there any way to hide a single row based on a value in the row? Or in a
value in another row?