Condititional Formtting a Column

M

Megadrone

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.
 
V

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

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
 
G

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
 
G

Gord Dibben

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

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


Gord
 
Top