Applying formulae to a range of data by using Conditional Formatting

Are you looking for a smarter way of monitoring the performance of Sales Staff?  By using Conditional Formatting one can apply formulae to a range of data. Only the data where the result of the formula is positive will be formatted. In that way it will be easy to monitor the performance of Sales Staff.  In the example below we use Conditional Formatting to format cells with green if the target has been met and red if the target has not being met.

 Applies To Excel:  2003, 2007 and 2010

1. For this example reference will be made to the screen shot below

2.  Select the data range A3:C25

3.  Select the Home Tab and as per screen shot below

4.  To identify employees who have met or  exceeded the target refer to the screen shot below

5.  Select OK

6.  To identify employees who have not met the target:

a.  Repeat steps 2 & 3 above

7.  Then select as below

8.  Select OK

9.  The  result will be as below

If you have any suggestions for an Excel Tips & Tricks topic, or you would like help with a particular function, please email enablement@alchemex.com and yours could be the next Tip of the Week.

Alchemex provides examples of MS Excel procedures for illustration only, without warranty expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The MS Excel procedures on this web site are provided “as is” cannot be guaranteed that they can be used in all situations

Further Reading:

1. Highlighting rows in which data appears using the conditional formatting formula function
2. Conditional formatting – Icon Sets
3. Conditional Formatting
4. Conditional Formatting
5. Using the transpose option, you can return a horizontal range of cells as a vertical range, or vice versa.