Condititional Formtting a Column

[Guest]

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.

 

[vezerid]

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

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

HTH
Kostis Vezerides

 

[T. Valko]

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

Biff

 

[Gord Dibben]

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

Format>Condtional Formatting>Formula is:

=A1<AVERAGE(A:A)

Format to a pretty pattern and OK your way out.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

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

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


Gord