Benchmark</SPAN> | Average</SPAN> | Variance</SPAN> | Cumulative Variance from Benchmark</SPAN> | |||
£568.00</SPAN> | £569.00</SPAN> | +0% | OVER |
<TBODY>
</TBODY><COLGROUP><COL><COL span=6></COLGROUP>
Hi
I have conditional formatting on Cumulative Variance so that if it says OVER then the cell is RED. If it says UNDER then the cell is green.
I also want to colour the Variance cell based on the same criteria for the Cumulative cell, but to use the OVER/UNDER text to decide on the colour.
Any ideas?
Thanks for helping,
Dave