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

Assuming Other is what triggers the formatting, select the cell where the
answer would go, go to Format-Conditional Formatting-change first dropdown
to formula is then type = click the cell it is checking, then type ="other"
then hit the format button, middle tab is Border, select the underline
border, then on the pattern tab you can select the color. Hope that gets you
there.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


" wrote:

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

Thanks that was exactly what I needed.
Regards,
Samm


"John Bundy" wrote:

Assuming Other is what triggers the formatting, select the cell where the
answer would go, go to Format-Conditional Formatting-change first dropdown
to formula is then type = click the cell it is checking, then type ="other"
then hit the format button, middle tab is Border, select the underline
border, then on the pattern tab you can select the color. Hope that gets you
there.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


" wrote:

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