Need VBA Help with INDIRECT Function + Data Validation

[Ramtrap]

Hello,

I followed this Contexture's advice on how to create a spreadsheet whereby data validation allows for type-ahead, larger text, etc. : http://www.contextures.com/xlDataVal10.html

The problem I'm having, however, is I don't know the VBA necessary to ensure that using data validation with an INDIRECT function keeps the formatting the same.

Example:

Column A has a List of Fruits (Apples, Bananas, Oranges)
Column B will display a list of option, dependent upon what Fruit was selected (ex: Apples = {Red, Small, Sweet}, Bananas = {Yellow, Medium, Bland}, Oranges = {Orange, Large, Citris})

I have no issues with creating the lists (Control + F3, create the named ranges, etc.). My issues stems (again) from the VBA. When I click the first box (Data Validation for a cell in column A shows all the fruits in Comic Sans MS, Font size 16, green) but when I click a cell in column B (which I'm doing Data Validation: =INDIRECT(A3), the VBA doesn't translate. I DO get the options in the list, but I'm not getting the formatting changes set by the VBA/macro.

Can anyone help me out with this?

Thanks!

Will