Conditional formatting applied to one cell based on the value of another

[Frank1545]

Hi all,

I am fairly new to excel and all that it has to offer. I am currently working on a sheet where I have to use the 5 directional colored arrow icons to indicate whether the values for a particular week/month are up or down compared to a fixed expectation.

The problem I have is that the sheet pulled data from other tabs and contains two bits of information an actual value in £ and the percentage change e.g. 1,227 +7.4%.

While I can extract the percentage change in another cell on the sheet I do not know how to apply the conditional formatting and my tolerances to the original cell based on the extracted values (the percentage change).

Any help would be appreciated!

Thanks in advance!

Frank

 

[oldbrewer]

1227	7.40%								0-30%	red
									31-70%	amber
									>70%	green
					a1 1227 is red
					cond formatting in A1
					formula is	=B1<0.31
					you should be able to do the next 2 yourself

<colgroup><col span="12"></colgroup><tbody>
</tbody>