how to prevent entering data with condition

[IsaIsa]

I have a sheet for evaluating work, where the evaluation is in the "D" column through a descending list (0,1,2, NA), it was required to add a comment in the adjacent cell in column "E" in case of entering any value except "2". How can I control that through formulas not VB. attachment is a part of the sheet. Thank you in advance.

ABCD.xlsx
	D
2
ABCD

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D2	Cell Value	contains "NA"	text	NO
D2	Cell Value	=2	text	NO
D2	Cell Value	=1	text	NO
D2	Cell Value	=0	text	YES

Cells with Data Validation
Cell	Allow	Criteria
D1	Custom	=E1*#REF!+#REF!*#REF!+#REF!*#REF!
D2:D7	List	0,1,2,NA

 

[dreid1011]

I am unsure exactly how you mean to control it, but I imagine some more data validation could work. Can you explain exactly what you want to do step by step?