Hi again,
along with the gridline challenge, I can't seem to find a way to print
the row numbers..  is there a way to do that.
this document has 11 pages horizontally, and total pages for printing

I'd like to perform a very tricky lookup (in my novice opinion).
The first step is that given 2 strings (in the item row) in 2
different columns like this:
     |    A    |    B      |

I'm using Excel 97, part of Office Pro Suite, and am trying to print
the gridlines in a large document.. I gone to page setup, clicked on
"Sheet" and ticked the gridline box, but it does not show in preview,
nor does it print the gridlines.. Am I forgetting to do something?

the below formula seems to work fine in excel 2002 but not in 2000.
=+IF(I2="0000-00-00";"";IF(I2="";"";IF(I2>NOW()-7;"W";IF(I2>NOW()-14;"W-1";IF(I2>NOW()-21;"W-2";IF(I2>NOW()-28;"W-3";"W-4"))))))
date format in column I:
14/06/2004

My organisation has recently changed financial year from Jan to Dec to April
to March.  All of our Pivot tables ran from tables held in sql and were
simply made up from two fields that were Year & Period (2001, 01), where 01
was Jan is now April.  We have converted all of the ...

I would like to create a formula which adds a range of columns up to a
maximum of a certain amount.
For example, the total sum is not to exceed 500.
If the total in a range of columns adds up to 455, I would like the "totals

I'm working on sumarizing daily data about stocks in my portfolio. Daily
price flucuations etc. I type in dates as 1/1/2004 for example. and I want
to click an drag all the way the the length of one year. Is there a way to
tell excel to do this but ignore weekend dates? so for ...

Suppose i have numbers in a column with datatype as text. But when i change
it to number it does not change until i press F2 in that cell.
Any help

In cell C25 I would like to place a formula that finds the closest cell
UP in Column A that contains the word "Arizona", and then returns the
value in column B for that row. For example: if A19 contains "Arizona"
and B19 contains 34.... and A14 contains "Arizona" and B14 contains 38 ...

Below is what the Excel XP Help says about linking, and it makes no sense to
me, nor does it work.  How do I really link data between separate workbooks?
What I want to do is see the same information in the Destination sheet as in
the Source sheet, and keep the info current. Merely ...

When I have a formula entered in a cell I want the back ground to chang
to a color. How do I do that with conditional formatting or is there
different way? I don't want it to change because of any particula
varibles I just want it to simply change color if a formula i

I need to create a seperate sheet in an excel workbook that contains th
information from a data sheet.
There are multiple columns and I need to seperate the rows out tha
match values in one column.

Please could someone let me know if this is possible, as I can't find a
definitive answer
In one column the cells will have random numbers from 1 to 5
I would like all 1's coloured green, all 2's, coloured blue etc etc, I can

Thanks in advance to anyone who can help me resolve this issue.
I've got a column of data that has the following formula in each cell:
=VLOOKUP(G52,Q3:R151,2,1)
I initially put this formula in the H2 cell and then copied it dow

I have a workshhet named Final Short Quote. Anywhere in Column C wher
the cell conatins the word Remove, I want to delete that row. How can
do that
--