Hi

I would like to know if the following is possible to complete as a
conditional formula.

I would like to look at one row of data, look at the first value (child) and
then go across and look at the second value (parent). Then test to ensure
that against a theoretical table that the relationship is correct. ie has
the user entered in the correct parent value for the child value.

Data set
Child Parent
BC001 BI001 Correct - Cell colour left blank
A5001 BI001 Incorrect - Cell colour turned red


Theoretical table
Child Parent
BI001 MH002
BC001 BI001
A5001 BC001

Many thanks Peter