valid data input

[mwvirk]

I am creating a buying/selling sheet where I have the buying date and quantity and then the selling date and quantity
I want to stop the user if the user enters the selling date less than the buying date and similarly sells less or more than the buying quantity
can someone please guide me?

Book1
	A	B	C	D	E
1	01-01-2024	Apple	500	18-01-2023	800
2	02-01-2024	Orange	300	19-01-2023	400
3	03-01-2024	Grapes	100	20-01-2023	200
4	04-01-2024	Mango	200	21-01-2023	600
5	05-01-2024	Banana	50	22-01-2023	100
6	06-01-2024	Coconut	200	23-01-2023	300
7	07-01-2024	Apple	600	24-01-2023	700
8	08-01-2024	Orange	100	25-01-2023	200
9	09-01-2024	Grapes	50	26-01-2023	100
10	10-01-2024	Mango	50	27-01-2023	200
11	11-01-2024	Banana	90	28-01-2023	900
12	12-01-2024	Coconut	100	29-01-2023	200
13	13-01-2024	Mango	300	30-01-2023	400
14	14-01-2024	Banana	200	31-01-2023	400
15	15-01-2024	Coconut	100	01-02-2023	200
Sheet1

 

[Siddharth Rout]

Read up on Data Validation. With data validation you can restrict the type of data that can be entered. Lot of examples if you search in Google. Try couple of them. If you get stuck then show what you tried and then we can take it from there?

 

[mwvirk]

Read up on Data Validation. With data validation you can restrict the type of data that can be entered. Lot of examples if you search in Google. Try couple of them. If you get stuck then show what you tried and then we can take it from there?

i cannot select the full range:

 

[mwvirk]

fixed. thanks

 

[mwvirk]

how can I copy this data validation for the remaining 2000 entries without impacting the existing date (data)

 

[mwvirk]

how can I copy this data validation for the remaining 2000 entries without impacting the existing date (data)

View attachment 112541

MWVirk PSX Portfolio v0004.xlsx
	AD
2	09-Feb-2021
PSX Trading

Cells with Data Validation
Cell	Allow	Criteria
AD2	Date	>F2