Condititional Formtting a Column
 

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.

Condititional Formtting a 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.

Condititional Formtting a 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.

Condititional Formtting a 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.

Condititional Formtting a 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.