Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
validation formula's and conditional formatting
I have created a drop down menu using 'data' - 'validation'. the options are
'1', '2', and '3'. there are a total of six cells that these numbers can can be entered into. My questions a A) i want to limit people from entering '1' maximum once, '2' max. three times, and '3' max. two times. B) i want an 'error' or 'alert' to occur if these max. limits of 1 once, 2 three times, and 3 two times is entered. Is it possible to do both of the options above? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
validation formula's and conditional formatting
Just enter a normal DV in cell A1 with a list of 1,2,3. But in A2:A6, use
custom with a formula of =OR(AND(A2=1,COUNTIF($A$1:$A2,A2)=1),AND(A2=2,COUN TIF($A$1:$A2,A2)<=3),AND(A2=3,COUNTIF($A$1:$A2,A2) <=2)) -- __________________________________ HTH Bob "VanessaS" wrote in message ... I have created a drop down menu using 'data' - 'validation'. the options are '1', '2', and '3'. there are a total of six cells that these numbers can can be entered into. My questions a A) i want to limit people from entering '1' maximum once, '2' max. three times, and '3' max. two times. B) i want an 'error' or 'alert' to occur if these max. limits of 1 once, 2 three times, and 3 two times is entered. Is it possible to do both of the options above? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting and validation | Excel Worksheet Functions | |||
Data Validation Conditional Formatting....or both? | Excel Worksheet Functions | |||
Stumped Conditional Formatting or Validation? | Excel Worksheet Functions | |||
Finding data validation and conditional formatting | Excel Discussion (Misc queries) | |||
Data Validation & Conditional Formatting | Excel Discussion (Misc queries) |