Conditional Formatting Blank Cells in Row if Column A Not Blank

[dream_avatar]

I need a formula to Highlight all the blank cells, but only the blank cells, in a row if there is a value in the first cell of that row.
So if

A=value B=blank C=value D=Blank

Highlight B and D but not C or A

 

[Joe4]

Assuming that you are starting with row 1, highlight all the rows and columns you want to apply this formatting to (including column A).
Then use the following Conditional Formatting Formula:

=AND($A1<>"",A1="")

and then choose your formatting color.

 

[dream_avatar]

Assuming that you are starting with row 1, highlight all the rows and columns you want to apply this formatting to (including column A).
Then use the following Conditional Formatting Formula:

=AND($A1<>"",A1="")

and then choose your formatting color.

Perfect, Thanks.