Greater than and less than using conditional formatting?

[Lesjoan01]

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Column H
[/TD]
[TD]Column I
[/TD]
[/TR]
[TR]
[TD]Amount
[/TD]
[TD]18/19 Costs
[/TD]
[/TR]
[TR]
[TD]£90,000.00
[/TD]
[TD]£0.00
[/TD]
[/TR]
[TR]
[TD]£10,000.00
[/TD]
[TD]£0.00
[/TD]
[/TR]
[TR]
[TD]£123,300.00
[/TD]
[TD]£124,000.00
[/TD]
[/TR]
[TR]
[TD]£10,000.00
[/TD]
[TD]£10,000.00
[/TD]
[/TR]
</tbody>[/TABLE]

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

 

[ElvTzh]

That still does not explain (at least I cannot understand it) why Raw Cost #2 and Raw Cost #4 are bold and the others are not. Please step through the logic step by step in detail, one column at a time.

Hi Peter,
The Raw Cost #2 & Raw Cost #4 is BOLD mean error as the price for Raw Cost #2 is higher than Raw Cost 1 and the Raw Cost 4 is actually lower than Raw Cost 5.
Which both of the price is not in descending method.

 

[Peter_SSs]

The Raw Cost #2 & Raw Cost #4 is BOLD mean error as the price for Raw Cost #2 is higher than Raw Cost 1 and the Raw Cost 4 is actually lower than Raw Cost 5.

So shouldn't it be raw Cost #5 that is Bold?
Then you would have ..
Raw Cost #2 bold because it is higher than Raw Cost #1 on its left and
Raw Cost #5 bold because it is higher than Raw Cost #4 on its left

To me, there is no error with Raw Cost #4 because it is lower than Raw Cost #3 which is descending as you wanted.

 

[ElvTzh]

So shouldn't it be raw Cost #5 that is Bold?
Then you would have ..
Raw Cost #2 bold because it is higher than Raw Cost #1 on its left and
Raw Cost #5 bold because it is higher than Raw Cost #4 on its left

To me, there is no error with Raw Cost #4 because it is lower than Raw Cost #3 which is descending as you wanted.

Hi Peter,
No, I manually BOLD it is to show you the error. if you see from the below table row 1 & 2

Raw Cost #1 (Conv.)	Raw Cost #2 (Conv.)	Raw Cost #3 (Conv.)	Raw Cost #4 (Conv.)	Raw Cost #5 (Conv.)
$ 0.00180	$ 0.00170	$ 0.00160	$ 0.00150	$ 0.00140	correct sequence (Descending)
$ 0.00140	$ 0.00150	$ 0.00140	$ 0.00130	$ 0.00140	incorrect sequence (due to the price updated in Raw Cost 2 & 4 is incorrect)

 

[Peter_SSs]

Sorry, I don't think I can help you because I don't understand why Raw Cost # 4 is incorrect. It is less than Raw Cost #3 and therefore it is descending.
Perhaps somebody else will understand your reasoning.