I want an empty given cell, say AA5, to become the color red when a
range of 8 cells in the same row starting 13 columns to the left of AA5
(i.e. the range is N5:U5) is blank. (To explain, if a payment was not
made over the 8 recent months, I want to get the automatic red

I have a worksheet that is composed with several pages (from jan-dec). On
this pages there is loads of input data.
My question is how to on a separate page calculate the average on all the
input data. When I have tried this it results in to many parameters, since on

       I am trying to ceate a SUM formula to add only the green filled
cells in a specified range. I am trying to do it with sum and
cell("color",reference) but I can't seem to be able to find color values. A
formula of: SUM(A3:E3) =CELL("color") simply returns a TRUE value. Any ...

I have been using the following formula to add the number of unique numbers
in column A.
=SUM(IF(FREQUENCY(CaseData!A:A,CaseData!A:A)>0,1))
HOWEVER,

When entering information into a cell, excel comes up with a error messages
that states " The value you entered is not valid. A user has restricted
values that can be entered into this cell".  The cell is formatted as General
and is not protected.

=A1=MIN($A$1:$C$1)

Can I copy or expand this to include al the cells down to A25,B25,C25

I am looking for the best price to make a purchase.
               A       B      C
Product      5       6      7
I would like to choose lowest price by changing it to a red font

I sure could use a little help.  I started with this If/Then statement
and it seems to get hung at what I understand to be the 1st "test".
I'm not sure what I'm doing wrong here......I'm loading this statement
for 8 different values (all under 500) and its supposed to bring back a

Can anyon help me out?
I have 3 columns A B C. In column A are the departments, B-Names and
C -Contributions.
A                             C

For one of my sheets, I need to sum all the values in A1:A10 for whic
the corresponding value in B1:B10 is less than 30. For example
A  B
2  40

I need to split up names in one field to multiple fields. I am using the
extractelement function. My problem: some fields have a title and some don't.
Therefore, I end up with the Title in the First name field and the first name
in the Last name field.

I need to know how to calculate the following sales commissions as shown
below:
Sales          Payment per order
1-10            £10

I have 2 columns of data, one column contains a rating on the level of
importance, and the other a rating of the level of satisfaction.
I need a function that will allow me to count the number of occurences of a
record where the level of imporance is high and the level of ...

I have a column (c) with dates...I have column (ba) with text data, sometimes
RIEP sometimes Charged with (some type of crime).  I want to have excel add
up the total occurrances of RIEP between 2 dates (ie quarter 1 = 1/1/2006 -
3/31/2006).  I am able to do this with the ...

I have a CF set up for a row:
=$D$12="Billable" then green back ground, and if non-billable then blue. The
colours are reversed based on selection and when I type in the box the colour
goes away. Any help?