Hi guys,
A little help required please.
I have a worksheet that looks like this;

J L
10 Y 1
11 Y 2
12 N 4
13 Y 3
14 N 5

Our staff will be inputting a Y or a N in column J and then selecting a
reason for that from a drop down menu in column L. A Y in Col J should only
be followed by a 1 or 2 in Col L (but some errors occur!). I want to add a
conditional format to Col J where if they enter a Y but then select something
from Col L that isnt a 1 or 2, for the Y to turn red.

Have tried a couple of IF statements but no joy.
Many thanks and keep up the great work!