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! |
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! |
All times are GMT +1. The time now is 11:38 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com