Data Validation List - Offset?

You could eliminate the data validation Error Alert, and use the worksheet change event to change the color names to whatever and change the font.

Doing that would flush the Undo buffer, which, IMO, is a heavy price to pay.

Thanks shg!

I probably won't have a choice as this is a required feature for this worksheet so...macro it is.

Thanks again.

Just wanted to update everyone on a fix I can accross for my issue:

Using a combo box to select my list (Green, Yellow or Red)
Cell Link is in an unused cell formated as white and returns 1, 2 or 3 respectively.

Using an If Statment I can pull the correct value and replace with the correct letter. So, selecting Green in the drop down box, Enters 1 in cell F1, which in turn enters "l" in D1, formatted as Wingdings using a conditional format to highlight in Green gives me a green circle. The same system provides a yellow square and a red diamond.

I placed my control box over the cell that I need to show the results in: D1.
In the format section I marked the control to not print.

When the worksheet is opened you can read the results, when it is printed it has the colorful shapes that my manager has requested. Good times.