select data in two fields

[maxronny]

dear all,

i have this question:

supplier	code	date	amount	number	select1	select2
1	465540	31/12/2019	100	11	red
2	56423	30/01/2020	200	22		red
3	3213	29/02/2020	300	33		red
4	897	30/03/2020	400	44	blu
5	32321	29/04/2020	500	55		blu

how can i select "red" in different fields? my goal is to have this issue by selecting "red"

supplier	code	date	amount	number	select1	select2
1	465540	31/12/2019	100	11	red
2	56423	30/01/2020	200	22		red
3	3213	29/02/2020	300	33		red

the other problem is that i cannot modify the script. so can i create, for example, a filter?

thank you for the attention.

[vamsee]

Maybe try creating a list box with the following condition

=if(select1='red' or select2='red','Red','Others')

Attached is the sample app 

[maxronny · Accepted solution]

dear Vamsee, thank you very much for your answer. my problem is a little more complicated. see the table below

supplier	code	date	amount	number	select1	select2
1	465540	31/12/2019	100	11	aa
2	56423	30/01/2020	200	22		aa
3	3213	29/02/2020	300	33		ba
4	897	30/03/2020	400	44	ab
5	32321	29/04/2020	500	55		cc
6	52	31/12/2019	600	66	dd
7	435	30/01/2020	700	77		aa
8	235	29/02/2020	800	88		ba
9	34534	30/03/2020	900	99	ab
10	5675	29/04/2020	1000	110		cc
11	87768	31/12/2019	1100	121	aa
12	98	30/01/2020	1200	132		aa
13	5	29/02/2020	1300	143		ba
14	33	30/03/2020	1400	154	ab
15	45454	29/04/2020	1500	165		cc
16	7	31/12/2019	1600	176	aa
17	88577	30/01/2020	1700	187		dd
18	675	29/02/2020	1800	198		ba
19	456	30/03/2020	1900	209	ab
20	56	29/04/2020	2000	220		da
21	68	31/12/2019	2100	231	da
22	80	01/01/2020	2200	242	aa
23	92	02/01/2020	2300	253		aa
24	104	03/01/2020	2400	264		ba
25	116	04/01/2020	2500	275	ab
26	128	05/01/2020	2600	286		cc
27	140	06/01/2020	2700	297	aa
28	152	07/01/2020	2800	308		dd
29	164	08/01/2020	2900	319		ba
30	176	09/01/2020	3000	330	ab
31	188	10/01/2020	3100	341		da
32	200	11/01/2020	3200	352	da
33	212	12/01/2020	3300	363	aa
34	224	13/01/2020	3400	374		aa
35	236	14/01/2020	3500	385		ba
36	248	15/01/2020	3600	396	ab
37	260	16/01/2020	3700	407		cc
38	272	17/01/2020	3800	418	aa
39	284	18/01/2020	3900	429		dd
40	296	19/01/2020	4000	440		ba
41	308	20/01/2020	4100	451	ab
42	320	21/01/2020	4200	462		db
43	332	22/01/2020	4300	473	da
44	344	23/01/2020	4400	484	aa
45	356	24/01/2020	4500	495		aa
46	368	25/01/2020	4600	506		da
47	380	26/01/2020	4700	517	db
48	392	27/01/2020	4800	528		cc
49	404	28/01/2020	4900	539	aa
50	416	29/01/2020	5000	550		db
51	428	30/01/2020	5100	561		ba
52	440	31/01/2020	5200	572	ab
53	452	01/02/2020	5300	583		da
54	464	02/02/2020	5400	594	db
55	476	03/02/2020	5500	605	aa
56	488	04/02/2020	5600	616		db
57	500	05/02/2020	5700	627		ba
58	512	06/02/2020	5800	638	ab
59	524	07/02/2020	5900	649		cc
60	536	08/02/2020	6000	660	db
61	548	09/02/2020	6100	671		dd
62	560	10/02/2020	6200	682		ba
63	572	11/02/2020	6300	693	ab
64	584	12/02/2020	6400	704		da
65	596	13/02/2020	6500	715	da
66	608	14/02/2020	6600	726	aa
67	620	15/02/2020	6700	737		aa
68	632	16/02/2020	6800	748		db
69	644	17/02/2020	6900	759	ab
70	656	18/02/2020	7000	770		cc
71	668	19/02/2020	7100	781	aa
72	680	20/02/2020	7200	792		db
73	692	21/02/2020	7300	803		ba
74	704	22/02/2020	7400	814	ab
75	716	23/02/2020	7500	825		da

my goal is to get a "filter" where i can select, for example, all rows "db" in fields "select1" end "select2" in the same time:

supplier	code	date	amount	number	select1	select2
42	320	21/01/2020	4200	462		db
47	380	26/01/2020	4700	517	db
50	416	29/01/2020	5000	550		db
54	464	02/02/2020	5400	594	db
56	488	04/02/2020	5600	616		db
60	536	08/02/2020	6000	660	db
68	632	16/02/2020	6800	748		db
72	680	20/02/2020	7200	792		db

"db" is an example, i could select "da" or any other...

Thank you averyone for your support.

Massimo.