i have a quick question
when using this set of formulas in the conditional formatting does it work
on text?
i am trying to alternately highlighting groups of months. for example i have

Is there a way to format cells to recognize dimensions as for use in formular
operations. i. e. 5'-6 1/4"

i currently have this formula
=COUNTIF(A1:A15,">5/18/2008")-COUNTIF(A1:A15,">5/22/2008")
if i want to pull the dates and put them in a separate field and reference
that field, how do i do it?  the syntax i have won't work.

THIS IS WHAT I'M USING BUT IF I ADD MORE TEXT I GET A ERROR MSSG SAYING I
REACH THE MAX TEXT.
ANY IDEAS?
THANKS

look in column A for date between 5/19 and 5/22, for each, go to column B and
see if the date falls within the range of 5/19 and 5/22, and give a total of
the dates which are outside of these date ranges.
tia

Ok, I'll do my best to explain this as thoroughly as possible.
I'm working on a Bill of Materials that uses a Pivot Table to count lengths
of wire sorted first by wire guage (size) and secondly by color.  From this,
I'm trying to lookup (from a separate spreadsheet) the part ...

I am trying to import contact information from an excel 2003 spreadsheet to
outlook.  When I go to outlook to import the information it says "an error
has occured in the microsoft excel translator while getting the contents of
file system.  The excel file has no named ranges.  ...

Can i use the if function with the cell function?

If the "FIND" function tells me the first position from the LEFT that a
certain character exists in a string, what will do the same starting from the
RIGHT side of the string ?

Trying to count the # of times specific text shows up within a specific time
frame (i.e., "Product A" that was completed between 7 am and 8 am)
This is the formula i was provided to count the # of times an item shows up
between the specific time frame.

I need to figure out a formula to figure out 75 workdays before the current
date.

Here goes...not sure if this can be done but you guys are the experts so
thought I'd ask!!  We have six columns, DA - DF and we want the formula in
DG.  The first three columns repeat themselves in the last three.  The first
three are titled "Season 0", "Season 1", and "Season 2" ...

I am trying to build an automatic reference to an external workbook.
E.g. using the formula
='http://www.geocities.com/gunther7039/[betonsportslines.xls]Sheet1'!$F$7
returns the value '9'

hi, i'm trying to look in column A for a date that falls within a specific
time frame, then look in column B to see if that date is > than the date in
column A, if it is, then add the qty in column C.
ex:

I almost found something here, but not exactly what I need.
I have 20 sheets named (tabbed) after different cities (let's say starts
with "SHA", ends with "SYD"). Their row 10 (from column F to Z) contains when
the sales happens (2008,2009 etc, BUT each has a different start). ...