ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Data Validation - List formatting (https://www.excelbanter.com/excel-discussion-misc-queries/143008-data-validation-list-formatting.html)

Gordon Smith

Data Validation - List formatting
 
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



Peo Sjoblom

Data Validation - List formatting
 
Format the cell with the validation the same way

--
Regards,

Peo Sjoblom



"Gordon Smith" wrote in message
...
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




Gordon Smith

Data Validation - List formatting
 
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

"Peo Sjoblom" wrote in message
...
Format the cell with the validation the same way

--
Regards,

Peo Sjoblom



"Gordon Smith" wrote in message
...
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






Peo Sjoblom

Data Validation - List formatting
 
I see, there is no way of changing that


--
Regards,

Peo Sjoblom



"Gordon Smith" wrote in message
...
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

"Peo Sjoblom" wrote in message
...
Format the cell with the validation the same way

--
Regards,

Peo Sjoblom



"Gordon Smith" wrote in message
...
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









All times are GMT +1. The time now is 10:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com