High Lighting Cells Depending on Text inserted.

Place the cursor in C2 cell and extend the selection below and Press Alt+O+D>>Formula Is

Use This Formula to Mark It as Green

Formula:

=COUNTIF($H$21:$I$32,$C2)

Click Add Condition
Use This Formula to Mark It as Red

Formula:

=AND(TRIM($C2)<>"",COUNTIF($H$21:$I$32,$C2)=0)