I have a range of cells that I want to use conditional formatting on.
I want the largest number in the range to be formatted or Highlighted or
something like that.
The conditions listed really don't seem to apply since the number may be

Hello, I need to create a worksheet that reflects exact payroll dates for
every month of 2006 and 2007.
Payroll is on the 15th and last day of every month.
Obviously I can do this manually, but was wondering if there was a way to

I have two files (a master and a detail) in which I pull through a
column from the detail to the master, using "=[Detail.xls]Sheet1!$A$2"
However I would like to configure the spreadsheets so that only data
which meets a condition is pulled in the master, in other words using

This may seem simple but for some reason I can't get it right.
I have a txt file that looks like this.
"aa","bbb","cccc","dddddd"
"aa","bbb","cccc","dddddd"

this is a two part question. i have a questionnaire (applicaiton) on the web
http://oregondistrictyouth.org/youth_camp_registrationonline.htm
how do i make it so the applicants can submit their answers, what do i do
with the submit button and also after they have been submitted, ...

I have a production report by company that includes a column for (# of
creations) and a column that is for the date.  The date goes by month
so that you have 1/1/2005 - 1/31/2005 and so on for each month for the
whole year of 2005.

I have problem with Pivot Table formula. I created a pivot table -
external data source. The pivot table is working fine, only problem
with formula.
E.g I have these fields :

Hi
I am trying to insert ticks and crosses into the cells in Excel 2000.
I understand the ASCII code for the tick is ALT+251.
When I use this code on a PC that is running windows 2000, it works.

in following code I have problem as it doesnt execute for every sheet
in workbook ...  i cant find the bug as it looks properly
Sub DAO_Import_planow_do_access()
' exports data from the active worksheet to a table in an Access

In Excel is it possible to calculate a persons age.
I have at the moment their birthdate in cell A2 and the Today() formula in
B2 and have done B2-A2.
It doesn't work, even formatting the cell incorporating the [h] format to

Hi. I have a subprocedure which works and which I run each week which
simply calls other subprocedures as follows:
Sub ByWeekAllReports()
   k = MsgBox("UPDATE dB. Use US date format mm/dd/yy. If no file

I have a large number of worksheets where the urls have been entered as
hyperlinks. I need to export the entire contents of these sheets as flat
files to be used elsewhere. Right now my problem is that I can find no
way of exporting the underlying url.

Could someone tell me what is the option to turn on in a listbox the
mouse wheel?
Thank's ahead!

When i use the vlookup function, it is returning the data in the row
ABOVE the row it should be pulling the data from.   E.g.
VLOOKUP(K345,$A$4:$F$336,3)  and k345 is St Francis, it is returning
value of 200, not the 300 it should return for St Francis.  

I have a question about sorting on the basis of date in Excel.
I have about 10 columns of data and one column contains the dates. I
now wish to sort the rows on the basis of dates, and the other nine
columns have to stick with their original dates.