Is there a way that when i enter in a value, lets say a1:a10 adds up and is a
negative number in cell a11. is there way to make that value automatically be
red?
Also is there a way not only to do numbers but also letters.

I need to generate a random list of day, excluding saturday and sunday,
between two dates. This is for assigning items to be counted as part of a
cycle count. I can generate the random list which more or less distributes
the items between the two days but it includes saturdays ...

I want to know how to create a simple frequency distribution

I am trying to convert inches to millimeters on a page of data . I can
convert a single number OK but when I try a whole page using cell references  
all I get is a refernce to circular equations which I do not understand as is
the case with excel help on circular references.  ...

I need to copy one row and then in another sheet "paste special" a "link",
not to one corresponding row but to several. Then I would have a block with
one reference like {=Medlemsregister!$B$90:$L$90}. The "block" acts like one
big reference of several rows corresponding to one ...

I am making facotring practice for my students and want to use the
randbetween but do not want it to recalculate everytime.

I would be nice to have Excel highlight and enlarge (zoom in) the current row
being viewed in the worksheet.  This would allow for easier reading when
looking at a spreadsheet with a lot of data.  This option could be configured
for font/colours, etc.  Would be very handy while ...

Is it possible to have two spreadsheets in two different files and cross
reference the data using excel vs. manually hand checking the sheets.  The
sheets are using text not numbers.

I have a very large excel table that my lab uses for test results. A
good portion of the table has been grayed out for various hardware
reasons. I would like to be able to count the number of shaded cells in
the table to get a completion percentage, and im not sure how (is there

I know what I want to do but I don't know how to do it, so I was hoping
someone could help.
I need a formula that when I subtract one column from another column
and the answer is in the positive range, meaning greater than 0 the

Some text cells that I format as numbers don't consolidate with others
originally numbers (obviously with the same content) in my pivot table. Does
anybody can help me, please?

I have tried this formula several ways and nothing works, please help
=IF(B6<=15.4,"/56)","IF(B6>=15.5("100"-B5)/84.5*B5/56") So basically if
cell B6 is less than or equal to 15.4 only divide by 56.  If cell B6 is
greater than or equal to 15.5 run the following formula

=AVERAGE(LARGE(A1:A60,ROW(INDIRECT("1:10"))))
This array  formula averages the 10th largest values in the Range
A1:A60,
I understand it:

We run a macro that selects duplicates and formats with background with a
color. We need to include that cell formatting in an IF statement. Can it be
done and, if so, what would be the syntax?

I recently helped a coworker who needed to translate dates into the days of
the week (from a concatenated string), so I used the weekday function to get
the numeric day of the week, then used a vlookup against a list of days to
get the name of the day of the week (e.g. 5= ...