Hi,
I want to do a formula that looks at the value in one cell and then if the one in the next cell is a certain value the cell colour needs to be yellow, green or blue.
So for example if the FSP is 4 and the target should be 1 so would be green, however if its 2 its better so would be blue and less than 1 would be below so yellow.
The FSP levels and what they would be if on target are
3 or 4 should equate to a 1a, 1b or 1c, 5 should be a 2c, 6 would be a level 2b, 7 a Level 2a and 8 a level 3.
Hope that makes some sense and someone is able to make head or tail of it,
Thank you in advance.
[TABLE="width: 192"]
[tr]
[TD="class: xl66, width: 64, bgcolor: #F2F2F2"]FSP
[/TD]
[TD="class: xl66, width: 64, bgcolor: #F2F2F2"]Target
[/TD]
[TD="class: xl66, width: 64, bgcolor: #F2F2F2"]Actual
[/TD]
[TD="class: xl65, bgcolor: transparent"]7
[/TD]
[TD="class: xl65, bgcolor: transparent"]2a
[/TD]
[TD="class: xl65, bgcolor: transparent"]3b
[/TD]
[TD="class: xl65, bgcolor: transparent"]7
[/TD]
[TD="class: xl65, bgcolor: transparent"]2a
[/TD]
[TD="class: xl65, bgcolor: transparent"]2a
[/TD]
[TD="class: xl65, bgcolor: transparent"]4
[/TD]
[TD="class: xl65, bgcolor: transparent"]2b
[/TD]
[TD="class: xl65, bgcolor: transparent"]2c
[/TD]
[TD="class: xl65, bgcolor: transparent"]5
[/TD]
[TD="class: xl65, bgcolor: transparent"]1a
[/TD]
[TD="class: xl65, bgcolor: transparent"]1a
[/TD]
[TD="class: xl65, bgcolor: transparent"]7
[/TD]
[TD="class: xl65, bgcolor: transparent"]3b
[/TD]
[TD="class: xl65, bgcolor: transparent"]3b
[/TD]
[TD="class: xl65, bgcolor: transparent"]7
[/TD]
[TD="class: xl65, bgcolor: transparent"]3b
[/TD]
[TD="class: xl65, bgcolor: transparent"]3b
[/TD]
[TD="class: xl65, bgcolor: transparent"]5
[/TD]
[TD="class: xl65, bgcolor: transparent"]2a
[/TD]
[TD="class: xl65, bgcolor: transparent"]2a
[/TD]
[TD="class: xl65, bgcolor: transparent"]6
[/TD]
[TD="class: xl65, bgcolor: transparent"]2a
[/TD]
[TD="class: xl65, bgcolor: transparent"]2a
[/TD]
[TD="class: xl65, bgcolor: transparent"]7
[/TD]
[TD="class: xl65, bgcolor: transparent"]3b
[/TD]
[TD="class: xl65, bgcolor: transparent"]3b
[/TD]
[TD="class: xl65, bgcolor: transparent"]7
[/TD]
[TD="class: xl65, bgcolor: transparent"]3b
[/TD]
[TD="class: xl65, bgcolor: transparent"]3b
[/TD]
[TD="class: xl65, bgcolor: transparent"]7
[/TD]
[TD="class: xl65, bgcolor: transparent"]2a
[/TD]
[TD="class: xl65, bgcolor: transparent"]2a
[/TD]
[TD="class: xl65, bgcolor: transparent"]6
[/TD]
[TD="class: xl65, bgcolor: transparent"]2b
[/TD]
[TD="class: xl65, bgcolor: transparent"]2c
[/TD]
[/TABLE]