Conditional formatting with an if statement

[Iknewthisguy]

Good afternoon,

I'm attempting to conditionally format a cell so if the cell to the immediate left reads "CP" and the cell I'm formatting is empty it's highlighted yellow. If the cell to the immediate left reads "CP" and the cell I'm formatting is anything other than empty it's not highlighted. If the cell to the immediate left is empty then the cell I'm formatting is not highlighted.

Sorry if this is confusing.

Any help would be appreciated.

Thanks.

Chris

 

[Sal Paradise]

With cell B1 selected

Format -> Conditional Formatting

"Formula" from the dropdown

=A1="CP"

Format -> Yellow highlight

 

[trunten]

if the cell you want highlighting is b1 then the conditional format formula would be:
=A1&B1="CP"

 

[Iknewthisguy]

I only want A2 to be yellow if A1="CP" and A2 is empty. If it has something in it I don't want it to be yellow.

 

[Sal Paradise]

=and(a1="cp",a2="")

 

[Iknewthisguy]

Thanks Sal. That's perfect.

 

[trunten]

I'm attempting to conditionally format a cell so if the cell to the immediate left reads "CP" and the cell I'm formatting is empty it's highlighted yellow. If the cell to the immediate left reads "CP" and the cell I'm formatting is anything other than empty it's not highlighted. If the cell to the immediate left is empty then the cell I'm formatting is not highlighted.

The formula I gave will work fine. Not to cause offense but the formula =and(a1="cp",a2="") will highlight your cell if the cell to the left contains CP and the cell one row down to the left is empty.

So long as you amended that to =and(A1="CP",B2="") then you'll be fine. But like I said =A1&B1="CP" also works. Horses for courses (and I'm lazy and like type less).

 

[Iknewthisguy]

Now that I look at it closer you are absolutely right. Your formula would work perfectly.

Thanks.

Chris

 

[Sal Paradise]

The formula I gave will work fine. Not to cause offense but the formula =and(a1="cp",a2="") will highlight your cell if the cell to the left contains CP and the cell one row down to the left is empty.

So long as you amended that to =and(A1="CP",B2="") then you'll be fine. But like I said =A1&B1="CP" also works. Horses for courses (and I'm lazy and like type less).

Quite right. Didn't think it through.