Data Validation - List formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gordon Smith - 16 May 2007 23:19 GMT

The source for my list has a simple format (text alignment -> right
justified). How can I keep that format active when using the data
validation dropdown?

Thanks,
Gordon

Reply to this Message

Peo Sjoblom - 16 May 2007 23:27 GMT

Format the cell with the validation the same way

Signature

Regards,

Peo Sjoblom

> The source for my list has a simple format (text alignment -> right
> justified). How can I keep that format active when using the data
> validation dropdown?
>
> Thanks,
> Gordon

Reply to this Message

Gordon Smith - 16 May 2007 23:34 GMT

I have both the cell which has the validation/list and the list itself (all
entries) formatted as right justified. The cells which make up the list
look correct, the value placed in the referencing cell shows up correctly
once a value has been picked, but the dropdown itself has the values left
justified.

Thoughts?

Thanks

> Format the cell with the validation the same way
>
[quoted text clipped - 4 lines]
>> Thanks,
>> Gordon

Reply to this Message

Peo Sjoblom - 17 May 2007 00:00 GMT

I see, there is no way of changing that

Signature

Regards,

Peo Sjoblom

>I have both the cell which has the validation/list and the list itself (all
>entries) formatted as right justified. The cells which make up the list
[quoted text clipped - 14 lines]
>>> Thanks,
>>> Gordon

Reply to this Message