Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple IF statement
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple IF statement
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",L102) 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). -- If this helps, please remember to click yes. "J.Scargill" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I think I need a multiple IF statement, or is there another way? | Excel Worksheet Functions | |||
If statement with multiple criteria and multiple results | Excel Discussion (Misc queries) | |||
Multiple If statement | Excel Discussion (Misc queries) | |||
Multiple IF Statement | Excel Worksheet Functions | |||
Help with a multiple OR statement. | Excel Discussion (Misc queries) |