Little Excel help here

i read all of that and it said nothing about typing in a word and color coding it for you

it just would color code duplicate entries that was it