can you use conditional formatting to change the color of text within a
cell if it contains specific text ?? or is there an easy macro to do same ??

I have a Userform with various command buttons in place. What I'm
trying to do is allow users to be able to open various Word documents
when they click on these command buttons via the use of hyperlinks
embedded within the click event of each command button.

I'm trying to sort a Ratings column which has entries of Low, Medium and
High. However an alpahbetic sort doesn't work out as I would like them in a
certain order. Is this possible? Its driving me crazey cos I get High, Low,
Medium.

I have a pivot chart with two axes one line and column. when i refresh
my pivot where the chart is based on my chart does not retain it´s
format. it changes to one axes. how do i prevent that happening ?. i
tried autoformatting and preserve formatting but nothing helps

you can make several pivot chart from one pivottable. But if change one
of the charts
the other related pivot chart en pivot also changes how do i prevend
that happening?

I need excel to return a value of 1 for every 10000 members. ie 10000 = 1 but
20000 = 2 and 100000 = 10 etc.  
Can anyone help with this Formula. It's probably very simple.

Below is an example of my spreadsheet.  I'd like to find the average
number of users for each "Day of the week" hour combination but I'm
not even sure where to start.
Date                      Hour    DoW       #  Users

Excel will not allow me to share my workbook.  Under the
tools/protection dropdown menu it allows me to protect the sheet, and
protect the workbook, but it does not allow me to protect and share the
workbook, nor to simply share the workbook.  I also have tried to

I have many worksheets in one file.  I have formulas on each sheet that point
to data on the first summary sheet.  The only change is which line number to
get data from.  I want to have one cell on each sheet with the corresponding
line number from the summary sheet, and have all ...

I prepare a monthly report of Firefighter's hours per day, fire calls per
day, medical calls per day, etc.  AT the end of each month, I total each
indiviidual's numbers of hours worked, number of calls run, etc.  How can I
then calculate totals-to-date from January's worksheet ...

The range Y6:Y399 contains a column of invoice dates formatted as DD/MM/YY.
I need to count how many invoices are issued each month. I thought the
following arrary formula would work to count January invoices, but does not:
{=COUNTIF(Y6:Y399,MONTH(Y6:Y399)=1)}

This has to be one of the most annoying things I have ever seen come out of
the Redmond collective.
If you import numbers into an excel 2003 spreadsheet, like 2003E152, it will
automatically format it in scientific notation.

I have a pivot table that will not group numbers in a column.  ie:
                Year
Group        2004    2005
10                        2

i want to copy a range of relative references to another range. then of
course it automatically changes its reference. BUt now I want de
reference to stay absolute for the whole range without manually typing
$ $. HOw do i do that?

I need to be ablt ro do d=b-c on each row, but not have it give a cumulative
total.