Check the two different cells in the same row
 

Hi all,

Could anyone tell me how to check all cells of the same column by the
following conditions:

1) if the cell (D5) is blank and the cell (A5) is not blank, then fill data
into D5

2) if the cell (D5) is blank and the cell (A5) is blank, then no need to
fill anything


Thanks for in advance.

Tlee