I have a validation drop down box for a cell. Let's say the valid values are
"BLUE", "Red", and "YELLOW". If I type in "blue" (lowercase), I want the
cell to find the value and display it in the correct case (i.e., "BLUE").
If I type "RED", I want the cell displayed as "Red"

How do I accomplish this?

Thanks,
Barb Ryan