How do I apply conditional formatting?
 

Im trying to apply conditional formatting so that those people who are below
average in sales should have their names formatted in red, italic and bold.

How do I apply conditional formatting?
 

Let's say we have names in column A from A1 thru A30. In column B we have
sales. Set the condtional format in A1 to Formula is:

=B1<AVERAGE(B$1:B$30) with a distinctive background and copy down the column


All the names with saless below average will be hi-lighted.

--
Gary''s Student


"Ken321" wrote:

Im trying to apply conditional formatting so that those people who are below
average in sales should have their names formatted in red, italic and bold.