Conditional Formatting multiple blank cells if first cell is not blank

[dancingducks29]

Hello!

I am trying to use conditional formatting to highlight the blank cells in a database, only if there is data in other parts of the row.

For example: if a cell in Column B has data then highlight the blank cells in that row from A to R. Here is an example of my data:

In this specific example the only cells I would like highlighted are E2, F2, G2, H2.
But if there was data in B11 then I would like the blank cells in A11 through R11 Highlighted.

I hope this makes sense!
Any help would be much appreciated!

Thank you in Advance!!

 

[steve the fish]

Try this CF formula:

=AND(A1="",$B1<>"") applied to say A1:R100 or whatever row you need to go to.