gwoolley0302
Board Regular
- Joined
- May 13, 2014
- Messages
- 55
Hi, I'm looking to apply conditional formatting based on the value of the adjacent cells. So using the example below, I want to highlight the figure showing for Q4 if it is 10% greater than the value in Q3. (However that figure in Q4 is a forecast in which I will be using trend function - not sure whether this makes any difference?). I have tried inputting formatting into the Q4 cell detailing that if it is greater than (C2*1.1) ... but this did not work. Does any one have any ideas ? Would be much appreciated. Thanks, Greg
<tbody>
</tbody>
Q1 | Q2 | Q3 | Q4 |
125 | 145 | 176 | (Trend formula) |
<tbody>
</tbody>