Formatting cells based on the value of another cell

[ciapul12]

Hi There,
How do I get excel to automatically format the cell where no value has been entered?
I want to use the formula in conditional formatting but cannot get it to work...
As you can see, I have a button that populates the first 3 columns with data, then columns D:I are all required to have the information for populated rows.
I need the formula to look at the row and see if data in column A,B or C has been populated and then check corresponding cells in the same row and highlight the gaps in red where no data has been provided.

Hope this makes sense...

Thanks

 

[Fluff]

What version of Excel are you using?
I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Maybe

=AND(D3="",LEN($A3&$B3&$C3)>0)