I have a list of dates, in ascending order.
I'd like to be able to alternate the cell colour according to month, i.e.
all Jan dates need to be blue, all Feb dates need to remain white, all March
dates need to be blue, all April dates need to remain white, and so on.

I have one sheet which is an order log and I have one sheet which is a issues
log.  I want to set it up that when I enter a customer reference on the
issues log (column F) , it searches the order log and finds the quote number
(column B of order log) and puts that in column E of ...

I have a database of 8000 records.  I have a second list of 728 job titles
which I have to extrapolate from the first list ie i only want the records
from the 8000 which match the job titles from the second list. What is the
best way to do this?

Is there any way of password protecting a specific hyperlink?
Cheers

I am looking for a formula to place in Data Validation / Custom so that an
amount cannot be placed in cell a2 unless a1 has a value in it and the value
in a2 must not exceed the value in cell a1.

I have a sheet that contains various functions which is updated
regularly.  The problem is, when updating, the formula never needs to
be changed, only the number.  I know it is possible to simply edit the
number in the formula bar, but I was wondering if there was a way to

am looking for a quick way to background-color every second row
grey.
So for if example I have used rows 3-76, I want to background colour
every 2nd rows 4,6,8,10,12,14,16,18,20,22,24,26,28,30...76

I receive a client data spreadsheet from my supplier that they can't change
so I need to change it to an easier format:
      A                B                C            D
1  01-Apr-07   useless data  amount

I know that I can apply conditional formating to a cell, but I require it to
be applied to a row, ie if a2 is equal to or less than a value then row a2
formatting has strike through applied to font an applied to all cells in that
row.

I have a user on Excel 2007 working in spreadsheet with macros (simple sort
buttons), i have set the macros to be enabled in: MS Office Button/Excel
Options/Trust Centre/Trust Centre Settings/Macro Settings/Macro Security,
however, this is not staying.  It is ok for the then and ...

Is it possible to have angled text and a straight border?  I'm trying to
create a two-line table, with v large fonts in Line 1 and smaller (angled to
help the fit) text in Line 2.  To aid clarity, I want the whole thing with
each cell bordered.  In past versions of Excel, I think ...

I'm using a macro to extract rows of data from a large, master CSV file -
breaking it down into chunks and re-saving it as smaller CSV files.
One of the columns in the master CSV file contains date and time data in the
format "dd/mm/yyyy hh:mm"

I think what I'm looking for is probably really simple but I just can't seem
to get it right!
Basically, I currently have an amount of hours in cell F56 (12:00), I want
to deduct the times shown in G56 (08:24) and H56 (01:00) and express the

i would like to learn if it is possible to restore a saved excel file. today
i made lots of changes in an excel file and then i saved it. but now i need
to bring back the original file. can i do this??

Excel 2003.  Cell A1 =Conditionally Derived Formula,   A1 is formatted Red
Pattern or remains Clear with a Value in it.
                 Cell A3 = I Need a C F Formula so that, 1. If I put a (1)
in A3 It will allow A3 to be Formatted to Red Pattern, If A1 is Red. 2. If