Is it possible to change the font for a validation list, specifically to change the colour of characters 11 and upwards for the names that appear in the drop down list?
I've tried changing the source list cells but it doesn't change what appears in the drop down list.
Any help would be most...
Let's say I have two columns A and B. I'd like to set data validation on B as follows:
-If corresponding row in A is some text then show list of valid input.
-If corr. row in A is blank then list of valid input is empty.
How do I do that?
Thank you.
I have defined a Name called 'Fruit' ranging from cell A1 to A3, say:
A1 = Apple
A2 = Orange
A3 = Banana
and i'll use this Name 'Fruit' as data validation (list) on sheet2 (source: =Fruit).
If i were to add on A4 = Kiwi, A5 = Peach and so on.. Can the Name range 'Fuit' be extended...
Hi there,
I have another question that I hope someone can help me with this time.
(It appears that my first question was a real stumper! See http://www.mrexcel.com/forum/showthread.php?t=421823)
My spreadsheet has a dynamic range dropbox validation in Sheet 1 Col T.
What I would like to...
Im trying to email directly from my worksheet by scrolling through a drop down list of emails that is in a validation List I set up.
I would like to choose the correct email and then click on the cell again whereon it opens a new Outlook email window to the selected email address.
I dont want...
Is there a way ,which i am missing, of scrolling a long validation dropdown list with the mouse wheel ?
I am thinking of setting a mouse hook for this (which i guess will be rather involved) but wonder if there is a simpler workround .
Regards.
Hi.
I´m trying to create a list from the validation menu but I don´t want to have the items for the list in any cell. Is it possible to create the list without using any cells, (for example, creating a name that stores the list and then using it)? How could I do that if it is possible?
I have...
I want a macro to run automatically (it changes several cells' validation lists on the basis of the text in the active cell) anytime the active cell is exited and the value in the cell has changed. (I use a validataion list to fill the active cell)
I have tried several versions of if statements...
Hello - I hope someone can advise. I am building a template in Excel and I want an error message (or any message) to appear to the user if they select from a static drop-down the same option in column I as in column J (i.e. they have to pick something different in each case).
Issue is I...
Help!
Reference cell A1 is a dropdown list
value selected in A1 needs to influence the display of other dropdown lists in A2 and A3.
So if user select "Book" in A1, then the list in A2 will display its list's for additional selections but the list for A3 will not show. If user selects "Car"...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.