Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data Validation / Cell Entry
Hi
Is there a way I can force a user to make an entry in a cell without using macros/code? EG: If the result of cell A1 = "XYZ" can I force them to make an entry in cell B1. ( If cell A1 = "" then no entry is required in B1). Hope that makes sense. Thanks Steve |
#2
|
|||
|
|||
This won't force the user, but it will make it obvious.
Format C1 in nice bold red letters and put a formula in that cell like: =if(and(a1="",b1<""),"Please clear B1",if(a1="xyz",b1=""), "please put something in B1","") (all one cell) If xyz just meant anything (not blank), then: =IF(AND(A1="",B1<""),"Please clear B1",IF(AND(A1<"",B1=""), "please put something in B1","")) Steve Jones wrote: Hi Is there a way I can force a user to make an entry in a cell without using macros/code? EG: If the result of cell A1 = "XYZ" can I force them to make an entry in cell B1. ( If cell A1 = "" then no entry is required in B1). Hope that makes sense. Thanks Steve -- Dave Peterson |
#3
|
|||
|
|||
Hi Steve
i can't think of anyway to achieve this without using code .. any reason why you don't want to go down that path? Cheers JulieD "Steve Jones" wrote in message ... Hi Is there a way I can force a user to make an entry in a cell without using macros/code? EG: If the result of cell A1 = "XYZ" can I force them to make an entry in cell B1. ( If cell A1 = "" then no entry is required in B1). Hope that makes sense. Thanks Steve |
#4
|
|||
|
|||
AFAIK, no. But you can black out the rest of the sheet
through conditional formatting and really annoy the user: 1. Select the range on your worksheet that the individual needs to see / work with etc. 2. Go to Format Conditional Formatting 3. Select "Formula Is" and put: =AND($A$1="XYZ",$B$1="") 4. Click on the Format radio button and format the pattern as black. 5. Put this formula in C1: =IF(AND(A1="XYZ",B1=""),"Please Fill In B1","") 6. Format the font white in C1. HTH Jason Atlanta, GA -----Original Message----- Hi Is there a way I can force a user to make an entry in a cell without using macros/code? EG: If the result of cell A1 = "XYZ" can I force them to make an entry in cell B1. ( If cell A1 = "" then no entry is required in B1). Hope that makes sense. Thanks Steve . |
#5
|
|||
|
|||
Thanks all for your answers.
I'm sure I'll be able to come up with something now. Many thanks Steve "Dave Peterson" wrote in message ... This won't force the user, but it will make it obvious. Format C1 in nice bold red letters and put a formula in that cell like: =if(and(a1="",b1<""),"Please clear B1",if(a1="xyz",b1=""), "please put something in B1","") (all one cell) If xyz just meant anything (not blank), then: =IF(AND(A1="",B1<""),"Please clear B1",IF(AND(A1<"",B1=""), "please put something in B1","")) Steve Jones wrote: Hi Is there a way I can force a user to make an entry in a cell without using macros/code? EG: If the result of cell A1 = "XYZ" can I force them to make an entry in cell B1. ( If cell A1 = "" then no entry is required in B1). Hope that makes sense. Thanks Steve -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation | Excel Discussion (Misc queries) | |||
Conditional data validation (using a filtered range?) | Excel Worksheet Functions | |||
Move the last entry in a column to a different cell, when the loc. | Excel Worksheet Functions | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Data Validation | Excel Worksheet Functions |