Data validation based on other criteria.

Hello,


I want to validate the data in each cell in a given column, based on the data in another column for the same row, then move to the next row and so on.


Example


A1 = APPLE so B1 must be GREEN or RED.


I want to put the list of acceptable inputs in another worksheet so they can be referenced and amended easily.


Any errors identified would need to be counted and the row copied to a report worksheet



Can someone help?


Ps – I have tried using normal data validation but am unsure of how to have the input checked against another column entry. I would like to try out both methods if it can be done?


Matt