Excel Beginner Question

[JacksonvilleBrewery]

All,
I will use column A and B as the columns I want to change:

I want to make column A Red if column A is not filled out but column B is filled out. But I want to leave column A White if Column B is not filled out. I have not been able to figure that out.

 

[Fluff]

Select Col A then > Home Tab > Conditional Formatting > New Rule > Use a Formula > =AND($A1="",$B1<>"") > Select the format you want > OK

 

[JacksonvilleBrewery]

Select Col A then > Home Tab > Conditional Formatting > New Rule > Use a Formula > =AND($A1="",$B1<>"") > Select the format you want > OK

That worked, thank you!

 

[Fluff]

Glad to help & thanks for the feedback