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
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
Last edited by a moderator: