Formatting According to Conditions

Hey,

I have added the conditional formatting (in Sheet2), you only need to add the rules for Absolute. They are the same as the rules for Percentile, just change "=(and($B2="Percentile"..." into =(and($B2="Absolute"..

Let me know if you need any additional help with that.

Julian

Edit: damn i got the shading for "Absolute" wrong. Use FDibbins instructions below.
And in addition to their instructions: to change the number of decimals displayed, when you change the format select the tab "Number" -> Number -> decimal places

1. highlight the range you want to apply the conditional formatting to (C2:F5 in your sample)
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =AND($B2="percentile",C2<=25) format fill DK GREEN

Repeat 3 and 4 with =AND($B2="percentile",C2>25) format Fille with LT GREEN
Repeat 3 and 4 with =AND($B2="percentile",C2>50) format Fille with ORANGE
Repeat 3 and 4 with =AND($B2="percentile",C2>75) format Fille with RED

Repeat 3 and 4 with =AND($B2<>"percentile",C2>=0) format Fille with DK GREEN
Repeat 3 and 4 with =AND($B2<>"percentile",C2<0) format Fille with RED