Entering a cell with Criterias
 

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 !!!

Entering a cell with Criterias
 

For just display, or printout purposes, you could use Conditional Formatting
to turn the font to white in C,D,E if no values in A,B
if they type something in C,D,E it would be there, but would not
show........

Vaya con Dios,
Chuck, CABGx3





"apache007" wrote in message
...
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 !!!

Entering a cell with Criterias
 

I don't believe you're going to do this without VBA. No worksheet function
can lock or unlock cells, nor can it force 'focus' or activecell to another
cell.

If you put IF formulas into C,D & E, they're going to be overwritten by
whatever the user types into them, regardless of the state of A and/or B.

"apache007" wrote:

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 !!!

Entering a cell with Criterias
 

Hi,

You can do this with data validation.

Select columns C, D & E as far down as you want this to apply starting in
Row 1 then

Data|Validation - Select CUSTOM and in the formula input box enter the formula

=COUNTA(A1:B1)=2

Click the 'Error Alert' tab and in the text box type a suitable error
message for the user.

OK.

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"apache007" wrote:

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 !!!

Entering a cell with Criterias
 

BRAVOOOO !!!!!

SIMPLE, ELEGANT AND TO THE POINT.

Thanks MIKE.

Cheers !!!


"Mike H" wrote:

Hi,

You can do this with data validation.

Select columns C, D & E as far down as you want this to apply starting in
Row 1 then

Data|Validation - Select CUSTOM and in the formula input box enter the formula

=COUNTA(A1:B1)=2

Click the 'Error Alert' tab and in the text box type a suitable error
message for the user.

OK.

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"apache007" wrote:

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 !!!

Entering a cell with Criterias
 

Glad I could help and thanks for the feedback
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"apache007" wrote:

BRAVOOOO !!!!!

SIMPLE, ELEGANT AND TO THE POINT.

Thanks MIKE.

Cheers !!!


"Mike H" wrote:

Hi,

You can do this with data validation.

Select columns C, D & E as far down as you want this to apply starting in
Row 1 then

Data|Validation - Select CUSTOM and in the formula input box enter the formula

=COUNTA(A1:B1)=2

Click the 'Error Alert' tab and in the text box type a suitable error
message for the user.

OK.

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"apache007" wrote:

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 !!!