I have a spreadsheet of data with a column of numbers. I need a formula that
will high light any number in this column the drops below an average of all
other numbers in the column.

Select the column containing numbers (say it is B2:B100)
FormatConditional Formatting...Formula Is:

=B2<AVERAGE($B$2:$B$100)

HTH
Kostis Vezerides

On Jun 6, 8:30 pm, Megadrone
wrote:
I have a spreadsheet of data with a column of numbers. I need a formula that
will high light any number in this column the drops below an average of all
other numbers in the column.

Assume the range of interest is A1:A10
Select the range A1:A10
Goto the menu FormatConditional Formatting
Formula Is: =AND(ISNUMBER(A1),A1<AVERAGE(A$1:A$10))
Click the Format button
Selet the style(s) desired
OK out

Biff

"Megadrone" wrote in message
...
I have a spreadsheet of data with a column of numbers. I need a formula
that
will high light any number in this column the drops below an average of
all
other numbers in the column.

Select the column.......I use column A

FormatCondtional FormattingFormula is:

=A1<AVERAGE(A:A)

Format to a pretty pattern and OK your way out.


Gord Dibben MS Excel MVP

On Wed, 6 Jun 2007 10:30:00 -0700, Megadrone
wrote:

I have a spreadsheet of data with a column of numbers. I need a formula that
will high light any number in this column the drops below an average of all
other numbers in the column.

Revision..........don't want blanks below data range colored if blank.

=IF(A1="","",A1<AVERAGE(A:A))


Gord

On Wed, 06 Jun 2007 11:19:12 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

Select the column.......I use column A

FormatCondtional FormattingFormula is:

=A1<AVERAGE(A:A)

Format to a pretty pattern and OK your way out.


Gord Dibben MS Excel MVP

On Wed, 6 Jun 2007 10:30:00 -0700, Megadrone
wrote:

I have a spreadsheet of data with a column of numbers. I need a formula that
will high light any number in this column the drops below an average of all
other numbers in the column.