change format based on other columns

[briannakmg]

I am having trouble with "if then" statements. What I need to do is have excel look at all of the cells in column K. If a cell is blank and the corresponding cell in:

column B says "X"
column B says "Y"
column B says "Z" AND column C says "L" or "M"

then the cell in the column K needs to turn yellow.

Any ideas would be so helpful!

Thanks,
Brianna

 

[Scott Huish]

Select Column K.
Click on Format, then Conditional Formatting.
Under Condition 1, change Cell Value is to Formula Is and put in the following formula:
=AND(OR(OR($B1="X",$B1="Y"),AND($B1="Z",OR($C1="L",$C1="M"))),$K1="")
Click on Format, then Patterns
Select a Yellow
Click OK
Click OK