Hi All,

I think this should be covered on my earlier questions. But I am trimming my
question way simpler, so that it gives a clearer picture.

I have coloumns as followed:

Coloumn A = Code
Coloumn B = Reff
Coloumn C = Date
Coloumn D = Description
Coloumn E = Amount

I would like Cells on coloumn C, D, E can only be filled IF
BOTH corresponding cell A AND cell B is filled.
IF empty, then can not be FILLED.

Example.

Cell C1 / D1 / E1 can ONLY be filled if A1 and B1 have value or NOT EMPTY.
Cell C2 / D2 / E2 can ONLY be filled if A2 and B2 have value or NOT EMPTY.
etc


If possible, can this be done withour VB.
Perhaps through data validation OR through IF formulas???

Thanks experts !!!