I have created a pricing matrix in Excel 2003 and I am trying to use the
conditional formatting function to highlight the top 3 cheapest prices in
each row. I have tried to set up the formatting, but I continue to get an
error message that says "Change the reference to a single ...

when downloading an Excel file from the Web, how do I get Excel to prompt me
to open or save the file BEFORE it opens?

I have a large apreadsheet. One of the columns contains an old date and one
contains an adjust factor. I need the new date. The fact that I'm dealing
with dates makes this difficult. Can you help me with my problem?
Thanks!

I am secretary to a society. We have 10,580 members. There are 4 categories
of membership. Each category of member pays a different annual fee to cover
annual expenses. Annual expenses are £2,500,000. There is a base fee and this
is calculated by dividing member numbers into ...

I  have two columns that change in length (dynamically). What I need is to
count the blanks in Colunm B but the column length changes every day. Is
there a way to count only the blanks within the data and exclude normal cell
blanks? If an end of row reference is needed maybe I ...

I have a large array (10x2200) of small integers. I have a second array of
three columns and about 200 rows. The first column of the second array has a
column number in the first big array (thus it has a value from 1 - 10) the
2nd and 3rd columns in the second array have a start ...

I already know how to "sort" using the A-Z and Z-A tools on the toolbar, and
I know how to perform multiple sorts using the Data menu, Sort...
BUT does anyone know if there is a "keyboard shortcut" for sorting?

When downloading an excel file how do I get it to ask me wheter I "want to
open or save this file?" without it automatically opening the file?

Simply cannot find it! All I wanted to find out is what would be the best way
to automate data entry i.e. there are three columns, 1st one with the venue
name, 2nd one with the address and the 3rd one with the postcode or zipcode.
So I have created the drop down list for the 1st ...

I am having trouble hiding the personal workbook so I can open 2 or more
sessions of excel without getting the error that workbook is locked for
editing.  I wrote a macro last week and can't get rid of the error.

I have a file that is used everyday and is set to Share Workbook, not share
workspace, so that multiple people can update the file at the same time by
saving any changes made.
What I want to do is use VB Code to select/deselect Share Workbook...

I work with 12 digit loan numbers which are assigned to a specialist based on
the last 2 digits.  I hope to find a way to sort on just the last two digits
so that loans are convieniently grouped by assigned specialist.

I have a chart from Excel but the labels do not fit in the available space
automatically allocated for that purpose by the program.  Thus, the left edge
of the chart overlaps the labels.  How do I resize the chart so as to give
more space for the labels?

hey gang,
easy one here (I'm assuming).  
ColAO contains 18 numbers, from AO3-AO20.  The numbers change constantly
while I input data.  How can I make the current high number change color?  I

How do I copy a date "03/28/08" in column "A" to paste as text "032808" in
column "B"?