Multiple IF statement

[J.Scargill]

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!

 

[Paul C]

for conditional formatting suing a formula you just need to make the formula
evaluate to true to turn on the formatting

for Cell J10 use the formula =AND(J10="Y",L10>2) for your conditional format
formula and set the shading to red.
Once you have this, just set the Applies To range as needed. Make sure your
references are relative, not absolute (i,e. J10 and not $j$10).