conditional formatting

[sheywood123]

I need to be able to turn a cell red in B12 if it is within 20%of the value in B3. It seems simple but I cant work out at all how to make it work.

Any help would be great.

thanks

Sean

 

[SteveO59L]

Cell Value Is

Between

B3*0.8

and

B3*1.2


Format Red

 

[sheywood123]

Yes that worked. Thanks

Taking this further, The user can enter a figure in to B3 which I now need it to match the formatting of a cell the value is closest to.
B C D E F

<TABLE style="WIDTH: 281pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=374><COLGROUP><COL style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2633" span=4 width=72><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3145" width=86><TBODY><TR style="HEIGHT: 13.5pt" height=18><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: transparent; WIDTH: 54pt; HEIGHT: 13.5pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 height=18 width=72 align=right>7.50%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 width=72 align=right>15.00%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 width=72 align=right>30.00%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 54pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 width=72 align=right>55.00%</TD><TD style="BORDER-BOTTOM: #ece9d8; BORDER-LEFT: windowtext; BACKGROUND-COLOR: transparent; WIDTH: 65pt; BORDER-TOP: #ece9d8; BORDER-RIGHT: windowtext 0.5pt solid" class=xl67 width=86 align=right>90.00%</TD></TR></TBODY></TABLE>


They are all different colours, if value B3 is closest to the value in D then green, if closer to the value in F then red.

Is this possible.

Thanks

Sean

 

[sheywood123]

if not then an easy way of matching them.

Thanks

sEan

 

[SteveO59L]

Which version of Excel are you using ?

 

[sheywood123]

2007

 

[SteveO59L]

Use the Conditional Formatting Wizard