| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Prevent entry based on another cell value
Hi every one
A1=5 B1=10 If C1 is is not between 5 and 10 then D1 is "locked" for entry. I suppose some sort of custom conditional formatiing would do this but Im not sure how to do it. Thanks! Melissa |
|
#2
|
|||
|
|||
|
Hi Melissa
click on D1 choose data / validation under allow choose custom type in formula =AND(C1A1,C1<B1) click OK Cheers JulieD "Melissa" wrote in message ... Hi every one A1=5 B1=10 If C1 is is not between 5 and 10 then D1 is "locked" for entry. I suppose some sort of custom conditional formatiing would do this but Im not sure how to do it. Thanks! Melissa |
|
#3
|
|||
|
|||
|
Melissa,
Select cell D1, then use Data | Validation, then choose "Custom" and use the formula =AND(C1=A1,C1<=B1) HTH, Bernie MS Excel MVP "Melissa" wrote in message ... Hi every one A1=5 B1=10 If C1 is is not between 5 and 10 then D1 is "locked" for entry. I suppose some sort of custom conditional formatiing would do this but Im not sure how to do it. Thanks! Melissa |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
| resolving a numeric cell entry for its meaning | Excel Worksheet Functions | |||
| changing value of a cell based on another cell color | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
| Returning a Value to a Cell Based on a Range of Uncertain Size | Excel Worksheet Functions | |||
Linear Mode
