I have a 12,000 row spreadsheet that contain sales tax received by various
businesses.  One particular business may have 2 records or 20 records.  Also,
there are two types of sales tax which are all in the same field
COMPANY NAME         TAX TYPE             AMOUNT

I would like to format dates prior to "today" in red. I have 2007.
My guess is I should use a formula when selecting a rule type, but <today()
doesn't seem to work.
Any ideas?

I would like to send an excel file to 2 person.
I want the first one to be able to open the 4 sheets and the second person
to be able to open ONLY the first 2 sheets (therefore I don't want him to see
the 2 'banned' sheets).

send me the excel questions answers with worksheet functions calcualtions
partand programming part to my mail id sraghur74@yahoo.com

Could anyone help me that I am writing a formula the allow me to bring the
date onto week ended Friday, for example cell A1=3 Sep 07 (Monday) cell B1
(where the formula will be) wil show me a result 7 Sep 07 (Friday) and/or
A1=7 Sep 07 (Monday) cell B1 will also show me the ...

Can I enter something into the custom section of an auto fitter so that it
looks for lines that just have one character e.g. an initial as apposed to a
name?
Thanks

I have around 30 worksheets. Each work sheet has some values in it. Around
10 to 1000 rows of data in each sheet. Now, I have to find a text called,
say, "apple" in all the sheets and print the sheet name, and rows values in
the 31st sheet.

I have a list box on a protected sheet that may be used by disabled people
without a mouse.
How do they use a list box just using a keyboard?
Many thanks

I have 3 columns in Col. A numbers between 1 to 10 in nearly 400 raws, in
Col.B Same numbers i.e. 1 to 10 which represents code of country shown in
Col.C and in Col.C names of Country like America, Brazil, China, India,
Pakistan, Barma etc.  I want to replace Col. A's numbers ...

I NEED TO KNOW IF THIS IS POSSIBLE.
I WANT SOME CELLS TO HAVE A CERTAIN DOLLAR AMOUNT VALUE TO EACH CELL. THIS
SHOULD NOT BE DISPLAYED IN THE CELL.
I WANT THOSE SAME CELLS TO DISPLAY DATES AS I ENTER THEM WHEN THE DATES PASS.

I have a spreadsheet with the following formula in cell L35:
=IF(B35="","",IF(ISERROR(GETPIVOTDATA('LOST MEMBERS PIVOT
TABLE'!A33,Calculator!$B35&" Total")),"£0",GETPIVOTDATA('LOST MEMBERS PIVOT
TABLE'!A33,Calculator!$B35&" Total")))

A    B        rating      60  65  70  75  80  85  90   95  100
74   E          A            0   0   0    0    0    0    0    0     0
84   C          B            0   0   0    0    0    0    0    0     0
86   D          C            5   4   4    3    3    2    1    0     0

I have list of people that I am constinly putting into different spreadsheets
for various reasons.  I want to be able to set up a drop down menu that lists
everyones names that I usually use on my spreadsheets, and then, after I
press the enter button all of their contact info ...

How do we apply the Philippine Peso (e.g. Php 1,450.00) and Euro decimal
(e.g. €1.450,00) in the same spreadsheet?

I have tried many things and I know a filter on the columns would do it but
then I would need to copy and paste to fill reports:(
I have a course register with a heading title for each column.
Each row is a unqiue record and I can limit the rows to match the amount of