Cell color will be changed based on its value compare with previous cell value

Dear all,
This is Nur once again, Cell color will be changed based on its value compare with previous cell value . if compare results value is greater than previous cell then its cell color will be GREEN , if less than then its cell color will be RED. But if previous cell value is equal to next cell value then next cell will be YELLOW. And this process will be continue till last non-blank ROW as well as till last non-bank Column. I have explained my requirement with the arrow sign in the attachment for more clarification..take care..

Hui Nur. Try:

Please Login or Register  to view this content.

Hi Mumps1,
It works perfectly & speed is extremely fast which is very much appreciated, thanks for Your valuable time ..take care.. nur

My pleasure.

Hi Holger. I noticed that as well and had come up with an addition of another loop in the code to deal with it.

Please Login or Register  to view this content.

This could be added at the bottom of the previous code. I didn't include it because I thought that it might be acceptable without it.

Hi Holger , now i got your point , thank for find out the issue what i was not noticed before..

Hi Mumps1, thanks for fulfillment my requirement & now it is 100% correct...

Hi Nur. Unfortunately, I noticed another possible problem. If you change cell E5 so that it is less than F5, it still remains green. Is this OK or is it a problem?

Hi Mumps1, yes that is not major issue , no need to work more , as i can move apart form this very well , thanks for concern ...Nur

Sounds good.