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.