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 [email protected] 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