Hi all.  I did try searching this group for answers, but couldn't find
an example for exactly what I'm trying to do, although I'm sure it is
quite simple (I'm and excel rookie...).
Two columns, A & B:

Excel2003 ...
Col A ... Text format ... values alpha-numeric & may repeat
Col B ... Text format ... values alpha-numeric & may repeat
(note:  Col B sorted in Ascending order)

I need to highlight a group of cells when the number in the qty box is
greater than 0.  I'm assuming I would need to do this with VB code. Am I
correct, and if so, can someone point me in the right direction?
Thanks for any help in advance.

Is there a way to print a fraction the way we write it - numerator positioned
directly on top of the denominator - not 3/4, 1/4, 1/2, etc?

I am trying to do an spreadsheet that will populate in the km's between two
cities, for instance in cells A2 and B2 I have drop down lists of several
different cites.  In cell C2 I would like to have the amount of kms between
the two cities chosen in cells A2 and B2 populate into ...

This maybe a dumb question, I know how to use the freeze function for cloumn
and rows, however is ther anyway to lock the Column Names, and Row Names in
such a way that woulld allow me to view the data in the body of the spread
sheet and still be able to have the column and row ...

I think this [Group] is causing me problems as all of the Data ribbon is
grayed out.  How can I remove this [Group] designation next to the file name
at the top of the screen?
Thanks

In Office 2007 Excel, my columns suddenly turned to numbers instead of
letters.  Now that all the menu options are different, the previous posts for
this problem are not helping me.  The Tools>Options>General tabs are no
longer applicable in 2007.

This question has been answered previously, but I need to get the 2nd
worksheet from each workbook.  Also, is it possible to do the same thing and
combine ALL worksheets from multiple files into a master spreadsheet.
Using the code below from another user's post (Bernie's code), I ...

Hey, I have the lovely excel 2000, and I just exited a spreadsheet
without saving it!
Yeah, dumb, I know.  But I opened another email attachment, and
thought that I was just exiting that document, when the entire excel

We have data that is downloaded to a .xls file from a SAP application.
The field in question is a 30 character field that contains all
numeric data. The problem is when opened in Excel the format of the
data is change to scientific notation and the right 7 characters are

I need to format numeric - decimal 9.0
size 15
i.e. 1.50 = 000000001500000
Thanks.

In custody dispute. Want to calculate number of overnights child spends with
me. Also want to put future custody schedule on worksheet calendar to
calculate number of future overnights.  Want to add certain holidays and
vacation schedule to custody cal.  Is there a template for ...

I have a question about a loan with draws.
I want to borrow $100,000 with four draws of $25K at 3 month intervals ($25k
now, $25K more in 90 days etc.).  The interest rate is 6%.  Repayment starts
in 12 months.  It is repayable over 5 years.

Ok, I'm making a spreadsheet and go to print preview. It shows the text in
the first
column and row(wordwrapped) as being 3 lines (or any column and row, but
shows some as one line, some as 2 lines , some as 3 lines)