Hi

In Conditional Format rules, try these 2 functions

=A1>A2 >>Yellow

=AND(A1>A2,A2>A3) >>Red