Multiple Conditional Formula Formating

[st471438]

Good morning everyone,

I have used this forum in past and this is a life saver site

I hope to get answer this time as well..........

So.. here what I am trying to do.. I am using Excel 2010 and I have average of performance that is in percentage example 18% on C3 and the rest of the column have individual's performance percentage and I want to apply 5 different conditions based on the average (18%) percentage so basically

So if the cell value is +1% then value of C3 (18%) then light green
If cell value is +2% of C3 = Green
If cell value is +3% of C3 = Dark green

If cell value is -1% of C3 = Yellow

and so on...

Here is the example of data

Name	OCt Sales	Nov Sales
Average	18%	17%
Sales Person 1	19%	16%
Sales Person 2	16%	18%
Sales Person 3	20%	15%

<tbody>
</tbody>

Please let me know what type of formula I should use? I tried using everything nothing is working for me.

I really appreciate everyone's help in this regards.

 

[Andrew Poulsom]

You need to add a new rule for each condition.

 

[st471438]

Ok I will try it right now THANK YOU, THANK YOU AND THANK YOU

 

[st471438]

It is working perfect except when I need to add color to cell when the difference of % is outside the specific number - example

I am going till +1%, +2% and at opposite side -1%, -2% of base cell BUT when I want to color all the cell that has value >2% OR <-2% then it is not working.

 

[Andrew Poulsom]

You can use formulas like:

=ROUND(C4-C$3,2)>2%
=ROUND(C4-C$3,2)<-2%

 

[st471438]

Thank you very much Sir!! I really appreciate your help.