Column H | Column I |
Amount | 18/19 Costs |
£90,000.00 | £0.00 |
£10,000.00 | £0.00 |
£123,300.00 | £124,000.00 |
£10,000.00 | £10,000.00 |
<tbody>
</tbody>
I need to highlight the above cells as follows:
If the amount in Column H is higher than the amount in Column I then the cell needs to be filled Red
If the amount in Column H is lower than the amount in Column I then the cell needs to green
If the amount in Column H and Column I are the same then no formatting is to be applied
Any ideas please?
Many thanks
Lesley