I am building a form with a bunch of drop down (validation lists) windows. In
some instances, an answer such an "Other" requires more info. How do I change
the background color and lower border in one cell based on the content of
another cell.

If the additional info is not required, I want the cells to the right of the
first answer to appear as the normal backgorund, but if there is additional
info required, I want the cell to be lt blue with a lower border so they have
a place to type in an answer...eg

What Hospital ? _________ (the cell with the lower border is blue and is
permanent)

What Hospital ? "Other" ______________

When the "Other" choice is accepted from the drop down menu, an additional
cell is given a lower border and the light blue background

Any help on this would certainly be appreciated.

Samm