I have two columns of figures (col M and N) - they are updated several times a second from outside XL.
I want to compare every pair of cells in the 2 columns - so M5 with N5 and M8 with N8 etc.
I want to color the cell with the largest value (of the 2) Pink and the cell with the lower value Blue.
So I will have a patchwork of cells in the two columns, all colored either Pink or Blue.
I have tried with code like this;
This does not work correctly - I have put the value of 2 in all the M column cells and 10 in all the N column cells to check and even if I run just the first block - it does not color correctly. If someone can give me some code that works I am sure I can adjust it suit exactly.![]()
Please Login or Register to view this content.
Thanks for reading.
Tobias
Bookmarks