Conditional cell color format

[SNGPresident]

I'm using Excel10 & searched the KB & am unable to locate a simular situation...

Column A Dept name
Column B Actual fiscal YTD Hours
Column C Estimated Hours for the year

the goal is to create conditional formating on the actual values in the rows ofcolumn B if they meet the following criteria:<o></o>
· if the value in column B is plus or minus a range of 10%of column C, then column B value should be Green<o></o>
· if the value in column B is =<10 of the value incolumn C, make column B Blue<o></o>
· if the value in column B is =>11% but <=25% ofcolumn C, make column B Yellow<o></o>
· if the value in column B is =>25% of column C, makecolumn B Red<o></o>

Any direction would be appreciated! <v:shapetype id="_x0000_t75" stroked="f" filled="f" path="m@4@5l@4@11@9@11@9@5xe" oreferrelative="t" o:spt="75" coordsize="21600,21600"> <v:stroke joinstyle="miter"> <v:formulas> <v:f eqn="if lineDrawn pixelLineWidth 0"> <v:f eqn="sum @0 1 0"> <v:f eqn="sum 0 0 @1"> <v:f eqn="prod @2 1 2"> <v:f eqn="prod @3 21600 pixelWidth"> <v:f eqn="prod @3 21600 pixelHeight"> <v:f eqn="sum @0 0 1"> <v:f eqn="prod @6 1 2"> <v:f eqn="prod @7 21600 pixelWidth"> <v:f eqn="sum @8 21600 0"> <v:f eqn="prod @7 21600 pixelHeight"> <v:f eqn="sum @10 21600 0"> </v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:formulas> <vath o:connecttype="rect" gradientshapeok="t" o:extrusionok="f"> <o:lock aspectratio="t" v:ext="edit"></o:lock></vath></v:stroke></v:shapetype><v:shape style="width: 11.25pt; height: 11.25pt; visibility: visible; mso-wrap-style: square;" id="Picture_x0020_1" type="#_x0000_t75" alt="http://www.mrexcel.com/forum/images/smilies/icon_smile.gif" o:spid="_x0000_i1025"> <v:imagedata o:title="icon_smile" src="file:///C:\Users\rv04445\AppData\Local\Temp\msohtmlclip1\01\clip_image001.gif"></v:imagedata></v:shape><o></o>

 

[NeonRedSharpie]

You've basically done all the work already. You just need 4 different rules:

Green

=AND(B1>0.9*C1,B1<1.1*C1)

Blue

=B1<=0.1*C1

Yellow

=AND(B1>0.1*C1,B1<=0.25*C1)

Red

=B1>0.25*C1

 

[SNGPresident]

You've basically done all the work already. You just need 4 different rules:

Green

=AND(B1>0.9*C1,B1<1.1*C1)

Blue

=B1<=0.1*C1

Yellow

=AND(B1>0.1*C1,B1<=0.25*C1)

Red

=B1>0.25*C1

1 Dept	Actual	FY Estimate	Forecast FEOY
2 PD	7500	10000	30000
3 PE	2500	15000	10000
4 PF	500	2000	2000
5 MD	300	7500	1200
6 MA	750	5000	3000
7 IA	15500	50000	62000

<tbody>
</tbody>

I think I need to be a bit more specific...what I'm looking to do is two things in the same cell:

I want the conditional format to change the color of the values in B2 based on the value in C2 (using the rules I mentioned)

So in the example above, I would like B2 to be Red.

Thanks