How to change the cell shade based on a percentage criteria?

Hi,

How do i change the shade of a cell based on a percentage criteria?

For example:

• *The target is 100
  *The actual score is 90 (10% less), this will be shaded orange
  *or the actual score is 84 OR LESS (16% or more), this will be shaded red
  *or teh actual score is 91 or higher (including 101 and above)(90% or more), this will be shaded green.

The formula or code cannot state these number, they are only example numbers. The target will be in, lets say, A1 and the actual will appear in A2. I need A2 to change its cell colour.

The cells that need shading will be based on formulas.

Use Conditional formating with 3 conditions.

If target value is in cell A1, and the cell to be formatted is B1:
Shade cell B1 red
For B1, use conditional formatting. Criteria are (both type "formula is"):
condition 1: =B1/$A$1>.9 this condtion results in green shade
condition 2: =B1/$A$1>.83 this condition reults in orange shade.

Hi,

I am still struggling to get this to work. I dont know why but i cant seem to find anywhere that lets me put a formula in. Or when it does it doesnt seem to be the right formula.

I am using Excel 2007 if thats any help?

Thanks.

^I've just been trying this and it still doesnt work.

I think it is because I am using negative numbers so division wont take it down to 0.??.

Any other suggestions on how to highlight cell colour based on percentage difference to a target number?

Look at the attached file which contains conditional formating you can modify to suit your needs.
Regards