Multiple Conditional Formatting in Excel

[privxls]

Hi Mr Excel,

I would like to ask a new favor from all of you who may have encountered this:

It goes like this:
-> =IF(D4>=D3) background is yellow
-> =IF(D4<D3) background is red
-> =IF(AND(D5>=D3,AND(D5>=D4) background is yellow
-> =IF(AND(D5>=D3,AND(D5<D4) background is blue
And so on... however, not all the conditons are being followed, how many conditions do I need to set? Or is this even possible?

Kind regards,
Priv

 

[FDibbins]

Happy to help (Pete did all the work though)

 

[Peter_SSs]

Thanks so much everyone, ..
Much appreciated guys

You are very welcome.