I have set up the condition that if, for instance, cell G7 has the text
"Yes", then all the text in the other cells in row G changes from red font
colour to black.
How can I copy this conditional formatting to all rows in the worksheet

I have "lost" my SEND button on my toolbar to send Excel created documents to
email recipients----HELP !!!

I have the following formula that I need in every cell of column G on my
worksheet
VLOOKUP(C:C,'Daily Code 10s'!1:65536,3,FALSE)
Obviously when I copy and paste this from one cell to another it changes the

In my excel sheet there are 2 rows
Date In           Date Out
23/05/06        24/05/06
23/05/06        25/05/06

I have datavalidation set up in a cell to pick up from a long list. Is there
anything I can do so that as I type in that particular cell it moves down the
list for selection?
i.e. if I type B it will got to the point of the list near B and when I type

Ok this has got me beat and maybe I am asking too much (of myself anyway!)
What I want to do is this:
I have 6 products let’s name them product 1 through to 6. At the moment
these products are on separate sheets in a workbook. The sheets are named

I've set up a mail merge document in Word using an Excel spreadsheet as the
data file, but everytime Word imports the data it adds about 10 zeros
following by a "1", so 23.4 becomes 23.4000000000001.  No matter how many
times a reformat the cell to only have 1 decimal place, I ...

I need to link to in excel file on my office intranet.  The filename changes
daily when reports are run but I haven't figured out how to link to it.
http://us.com/reports/production/myfile_20060430.xls
This is the only file in that folder with that name, so if I can get excel

I'm using VLOOKUP function to search through col A to extract data from
col B within the same row. However, there are multiple data in col A,
which fulfil the condition defined in VLOOKUP. The function finds only
the first cell that fulfills the condition. Is there any way how to

Hello from Steved
I have 7:10 p.m. to  12:15 a.m.
What formula do I use to subtract  12:15 a.m. from 7:10 p.m. please.
I would like it to show 05:05

I have 5500 or so rows/lines of data with 5 columns. Column A is
program1's last names, B is program1's first names, C is just a visual
barrier between name sets, D is program2's last names, and finally E is
program2's first names.

I have this formula:
INDEX([POlog.xls]POLOG!$O$5:O2003,MATCH($H5,[POlog.xls]POLOG!$P$5:$P2003,0)),
but I want to find the Match in Range(P5:X2003) not just (P5:P2003). In
other words, I want to find the match for H5 in multiple columns. Is it

Here is what I am trying to accomplish:
1. I have 31 cells across like the days of the month.
2. I am using a ISTEXT formula to conditionally shade the cell if another
cell on the worksheet is populated

We have a spreadsheet at work where in B16 we use this formula:
=SUM(B15/2000*15.32)
That is good except when B15/2000 is less then 95.  In that case we
need to just multiply 95*15.32.  Is there anyway to do this in one step

I wish to click on a single cell and have a row of data show
elsewhere.
i.e I have four rows of data in a worksheet.
One is green one red one yellow and one white.