Looking to write a code:
If any cell in column B ="red" and a value other than 0 is entered into the corresponding row in column J then a message box appears.
So if B3 = "red" and the user enters 300 into cell J3 the mesage appears.
Can anyone help.
Bookmarks