| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 !!! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 !!! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 !!! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 !!! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 !!! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 !!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Entering digits in a cell with numbers already inside cell | Excel Worksheet Functions | |||
| Entering value in the cell | Excel Discussion (Misc queries) | |||
| Entering value in a cell | Excel Worksheet Functions | |||
| after entering a text in one cell, next cell should disp the entd | Excel Discussion (Misc queries) | |||
| How do you do hard returns in 1 cell? entering address in 1 cell | Excel Discussion (Misc queries) | |||
Linear Mode
