Data Validation


User Input	Output	Instruction:
lssssdfsf	Green	Feel free to test the data validation formula by:
test	Red	i. changing any input in the range A2:A20, or
blue	Blue	ii. extending the output range by copying any cell in the range B2:B20 and pasting it underneath.
H	Green
G	Green
r	Red
fds	Blue
ASSS	Black
b	Black
sds	Red
fds	Blue
dfdf	Blue
black	Black	test
dfdf	Blue
white	White
[white]	White
(white)	White	green
grey	Green	g
oo	Green
marie	Green
hhhhhhh	Green
blu	Blue
hhhhhh	Green
w	White
wh	White
r	Red
dsdsds	Blue
sdsdzzz	Red
w	White
ssssssssss	Red
qsq	Green
w	White
sssss	Red
aa	Black
aa	Black
a	Black
G	Green
e	Blue
	#N/A
bb	Black
blu	Blue
	#N/A
x	White
r	Red
bb	Black
blue	W
nn
aa	b
white	b
dd
blue	Blue
test	dfd

Input