in a footy tiping spreadsheet, higest scores of the round is 12, 4, 8, 12 & 12
i want to highlight the cells with the highest scores 'conditional format'
and leave the lower scores plain.

The following macro removes the formula in a cell.
Sub cpyvalue()
   Dim i As Long, j As Long, K As Long, tmp As Long
   j = Worksheets("school").Range("k1").Value

I have a table of data that I carry out a number of calculations on. However,
I am having a problem calculating one value. Below is a sample of the data:
Job no     U    C    P    Machine     MRs
88    1    3    1    A    1

I have a speed sheet that I update and save as html on a weekly bases. It has
several colums that are not used all the time. I would like to hide the
unused colums then save as html, but Ive tried the hide and when I save it it
only shows the last 2 colums on the sheet. the ...

I have three columns each with different numbers.  Column A has only two
numbers, Column B has 7, and Column C has 5.  I need to know when the numbers
in Column A and the first two numbers in both Columns B and C do not equal.  
I created the formula =IF(OR(A1<>LEFT(B1,2),LEFT(C1 ...

how do you set up a link that can be clicked on that sends the data on the
spreadsheet that the link is in via email as an attachment or a page etc

How do I show the actual and the forecasted amount on one data series in a
column chart (like a stacked column)?

Hi, I am trying to create a formula and I get #REF in return.  The formula is
=VLOOKUP(B190,I190:I241,2,FALSE).  What am I doing wrong?

how can i get insert table and draw table icon in my tool bar?

From A1 to A100, i got value from 1 to 100 (A1 will be value 1, A2 will be
value 2 and so on).
how do i get excel solver to choose for me cells that can possibly add up to
a value of 22?

It should not be too hard but I am unable to find a solution.  
I want to take a specific word from a cell and place it in another.  
I have in the cells  with addresses eg"1955 BOUNDRY ROAD RD 3 AUCKLAND" and
I wish to split it to three cells, "1955 BOUNDRY ROAD"  "RD 3"  ...

im trying to add the quantities in one column based on if the dates in the
corresponding cells in another column occured within the past week
ive tried a nested sumif formula and a dsum but neither work very well
thank you,

Im trying to select the last date in each of about 1000 seperate 50 row lists
in a worksheet using a single cell at the top. Is there a formula that can do
this?
thank you,

I'm trying to increase the scrollbar height in excel. The help menu states to
go the Microsoft Windows Control Panel and click on tabs inside of the
display box. I do not know where or can get to the Microsoft windows control
panel  so that I can increase the scrollbar height. ...

I know this is do-able, as I've seen it before. I just don't know how to do
it. What I'm trying to do is create an excel spreadsheet for vacations here
at work, where the cells will automatically fill in with a pre-determined
fill/background color when the text letter "V" (for ...