How do I apply conditional formatting?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed with conditional formatting and adjacent text 3
Excel Conditional Formatting Removal 7
Conditional formatting on a dynamic range - workaround 1
Conditional Formatting: Formula is 2
Conditional Formatting with Icon Sets 0
Conditional Formatting 1
copy conditional formatting range 3
I want to conditionally format an entire column after 1 year from 1

Back
Top