HELP......Conditional format issue

[juca73]

Hi Guys/Gals,

First post and probably an easy one to get solved. Firstly i'm quite apt in the basics and know my way around excel but formulas etc are my achilles heel. Secondly what i require is formula only no VBA coding.

OK, I have a value in column U ( this is determined on the figure in column V ) i have conditionally formatted Column U to the following

• Between 0 - 0.9 cell turns RED
• Between 1 - 1.9 cell turns AMBER
• Greater than 2.0 cell turns GREEN

What i need is for column C to turn to the colour based on the value of column U. I believe i will need to have three different conditional formats as i have in column U but i cannot get it to work. Can anyone help with the formulas please.

Thanks in advance

 

[oldbrewer]

[TABLE="width: 758"]
<colgroup><col span="7"><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]A col color[/TD]
[TD][/TD]
[TD]this is row 1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[TD][/TD]
[TD]red[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]0.7[/TD]
[TD][/TD]
[TD][/TD]
[TD]red[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]0.99[/TD]
[TD][/TD]
[TD][/TD]
[TD]red[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD]amber[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]1.4[/TD]
[TD][/TD]
[TD][/TD]
[TD]amber[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]1.99[/TD]
[TD][/TD]
[TD][/TD]
[TD]amber[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD][/TD]
[TD][/TD]
[TD]green[/TD]
[TD][/TD]
[TD][/TD]
[TD]Between 0 - 0.9 cell turns RED[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]2.5[/TD]
[TD][/TD]
[TD][/TD]
[TD]green[/TD]
[TD][/TD]
[TD][/TD]
[TD]Between 1 - 1.9 cell turns AMBER[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]25[/TD]
[TD][/TD]
[TD][/TD]
[TD]green[/TD]
[TD][/TD]
[TD][/TD]
[TD]Greater than 2.0 cell turns GREEN[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]999[/TD]
[TD][/TD]
[TD][/TD]
[TD]green[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 4"]you need 3 cond format equations[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]for red[/TD]
[TD]=B2<1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]for amber[/TD]
[TD]=B2<2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]for green[/TD]
[TD]=B2>=2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]