change format based on other columns

briannakmg

New Member
Joined
Jan 26, 2006
Messages
42
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
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
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
 

Watch MrExcel Video

Forum statistics

Threads
1,113,794
Messages
5,544,322
Members
410,603
Latest member
rseckler
Top