I have a assignment to do and I am having trouble with opening a file

How can I apply cond.formatting below ?
If col A and col B empty no format
If both col A and col B with data no format
If only one of them is with data then formatted

All I want to do is total the value of cells that are hi-lighted in a
certain colour. In other words; I have set up my spreadsheet that when I
have a outstanding/not paid invoice; the value for that cell's background
color is red. I would like to have the spreadsheet add up/total ...

Me again, this is my second question to the newsgroup, with the first
one I got helped so fast that this can be addictive.. ;-)
I've got this range of standard values in a colum.
Lets say A1 till A10 contains values that can be changed by the one

Excel 2003
Cell A1 is named MyCell.
Cell A2 has formula "=MyCell".
I rename cell A1 in the toolbar to NewCell.

I have a spreadsheet with 4 form buttons on it that will run different
macros.  Is there any way to make it so the user can't click on any
part of the worksheet except for the buttons?
I don't want a message to pop up, I just want Excel to ignore if the

How do you arrange a column of birthdates so that the days are in an
ascending order? Excel automatically arranges it according to age. If
anyone knows, please help. I've tried about everything! Thanks.

Hi Folks - I have an .xls file with a zip code column entered as text. I
need to send the file to the feds as a csv file. When I Save As the xls file
to a csv file, I lose the leading zeros in the zip code. Any ideas?
Michael

I've got a spreadsheet where I need to put an asterisk into a cell
under certain conditions. I know roughly how to do it, but as someone
who has yet to master the finer points of Excel syntax, I am having
trouble putting all the punctuation marks, cell references and

Excel 2002 SP3
Win XP HE SP1
*Follow-up to: microsoft.public.excel*
in cell A1, i have text string ABCcompany.

Being a newbie to VBA could I please have some advice .
What I am trying to do is write a macro to select the active sheet and
create a copy of it but then I would like an input message to ask me
what to name the sheet so that I am presented with an exact copy

Can anyone please give me some guideline on how to draw a chart with y-axis
is the count of the item in x-axis?  I am using Excel 97. Thanks.

Chart
Y-Axis goes from 0 to 70units
X-Axis goes from 1Jan2006 to 1March2006
What I'd like is 2 trend lines:

what conclusion do I draw from a scatter chart ? Thank you.

Is there a way to "reprogram" the [+] key on the number pad to move right to
the next cell like the [TAB] key does?
I have a user that is data entering information in an Excel list (4-5
columns of data) and would like to keep her data entry hand on the number