Hi,
I have a dropdown validated list users must choose from.
Is it possible to align text right or left on condition?
i.e.: if "- Please Select -" align right; if any other value selected align left.
Is it possible to decrease font size only for a particular choice in the list?
Thanks!
Hi xlepws,
As i know conditional format can't do test alignment & font size.
You can set Font Style, Underline, Color and Strike through;Highlighting, text border, icon
-If the problem is solved, please mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved".
-Always upload a workbook before start your question
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.
+++ If my answer(s) helped you, please add me reputation by click on * +++
yea but my aim was to automate the process..so how can I say "if A align left; if B align right"? only through VB?
VBA can do it, but is this neccesarry? Highlighted color can make the big different as well, can consider that
Set cell for left align. For right aligning, set the CF format for Number to Custom using the following coding: #,##0* ;;;* @
Wow, it worked. Learned, thanks jhren.Originally Posted by jhren
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks