(VBA) Check cells in sheet against cells above and to the right

.
Not certain what your macro does but it appears you were missing an END IF ...

Please Login or Register  to view this content.

Well that clears the error - so thanks for that.


The result is the inverse of what I want though - I only want the 2 yellow cells to turn red (they will not normally be yellow) as they are of a lower value than of the cells that are EITHER above them or to the right of them!

vb error 3.png

Hmmm, I think a > should be a <, or vice versa.

Can't test until tonight though.

See attached

This code highlights cell "M22" The two cells you have highlighted do not have a greater value above them or in one case to the right

Please Login or Register  to view this content.

Originally Posted by nigelog

See attached

This code highlights cell "M22" The two cells you have highlighted do not have a greater value above them or in one case to the right

I'll check your code when I get home.

However, the 2 cells highlighted do have greater values to the right.

I'm not just interested in the cell immediately above or to the right, but if ANY cell above and to the right had a greater value.

All of these cells are less than a cell to the right

Excellent, I'll look at your code when I get home, but in the face of it, I think you've cracked it.

Thank you.

Yup - all sorted. It was the > in the the j loop that should have been a <.

Thank you.

Glad to help...