VBA Code to Match US Region to the State that is entered

[pawcoyote]

Testing it out. I did notice the following code

.EntireRow.Cells(colRegion).Interior.Color = vbRed

It is not coloring the Region field when empty.. If that is suppose to do that.. Also How can I change the Color of the Cell to be a ColorIndex and the Font to a different Color and then revert back to the default of no fill and auto font?

I missed a check

Try ver 13