Say your data in column A looks like:
     John Smith
     123 Maple Ave.
     Springfield, NJ 081234

I am using the below to auto change color if it meets the condition...
=IF(F26>=0,IF(OR((F26)<=2,(F26)>=-1),"GREEN",
IF(AND((F26)<=2.5,(F26)<=-1.5),"AMBER","RED")),
IF(AND((F26)>=2,(F26)<=-1),"GREEN",

Is there a function or a simple formula that will return a date from a
week number?  For instance, a week for my company starts on a Sunday.
Week 15  on my calendar begins with 04/06/08.  I would like to enter
15 and have it return the first day of that week which is in my

How to hide the status bar in Excel 2007 and in Office 2007?
Why does Outlook 2007 send message window appear in 30 seconds after sending
a small file from an Office program or choosing the send command from the
file context menu?

Is it possible to use conditional formatin in Excel 2003 to:
value cell is in red if it's format is accounting - Dollars
value cell is in blue if it's format is accounting - Euros

I want a template for a delivery note ie I am delivering some items & my
customer will sign for receiptl

On my spread sheet the relevant account currency is entered in column B. Can
other columns be formatted to bear the currency symbol entered in column B.?
E.g if A contains USD  can G show as USD100.00 when 100.00 is entered and
will it still be a numeric value?

Hi, I need to format text and numbers, but I keep messing up.
For example, I want to format
A12345678901 so that it will appear as
A123-4567-8901

Anyone out there clever enough to tell me how to sequentially populate
the comments field in cells... the problem I can see is that the cells
are in a grid of A5-10 through to i5 to 10, I want them populating
a5,a6,a7,a8,a9,a10,b5,b6 etc and when I get to i10 I want the sequence

=sumproduct((g23:g5000=6.5)*(q23:q5000))
=sumproduct((g23:g5000=16)*(q23:q5000))
=sumproduct((g23:g5000=3.4)*(q23:q5000))
All of the above formulas work individually, but I I want to combine

i  have a worksheet of daily fee collection with this formula check on classess
=IF(E5="Play Group",3940, IF(E5="Nursery",3980, IF(E5="Kindergarten",4020)))
(where as 3940,3980 and 4020 is fee)
i want to calculate the late fee amount of 15 per day after each a specific due date like ...

Hi i hope some one can give me a hand i have this example in excel where i
have the month in this example its Apr and then i have the table below it and
what i want is it to calculate where is  the Apr is right up to Jan I thought
i could do it with the SUMIF but it does not ...

I made a simple scatter plot in Excel and found an outlier. I want to
keep the outlier anyway on the chart while fitting a trend line with
all the data points except the outlier. How should I do it?
Thanks,

Hi all, I am new to macros and VBA. Have a question concerning SumProduct.
I have a worksheet with 20 something active columns. In a for-loop I want to
ad dates from column G that depends on values from two other columns B and F.
I am trying to use SumProduct in VBA. See ...

I have several applications where I keep monthly data on tabbed worksheets,
labled Jan07, Feb07, Mar07... I also add a worksheet I usually call RangeEnd
that acts to stop sums for ranges.  It has been my practice to make a year
end worksheet that would have the same shape data ...