Forum

Hello Frans, Great that you found a working solution. Have an Excellent day now! Br, Anders Sehlstedt

Hello Frans, Q1: As a Swede my regional setting for a date is YYYY-MM-DD, so when I type in 16/8/22 or 16-8-22 in a cell that has number format Dat...

Hello Frans, Now I don't know if you intend to have some text in those cells which you are colouring, but if not then a simple and macro free examp...

Hello Hava, As Clark mentions, you can easily do such by using a list or table where you have the different words or sentences listed. I have crea...

Hello Willy, I am not really sure if I understand your purpose here, but I understand it as such that you have a list of names and from that list y...

Hello Elinor, The solution given by Frans is better than the one I am to provide here, but I give you my reply just so you can see how this can be ...

Hello, That's great you found a solution. Br, Anders

Hello Sunny, You're correct. I missed that "tiny" detail that it is a table. Luckily some of us have eyes which they use. Thanks! Br, Anders

Hello, I am just a basic user of VBA, but I will try to give some help anyway. What first strikes me is that your range where you copy the data fr...

Hello, I found this tip from a search engine. Br, Anders

Hello Gordon, As I see it, if you want to use the current layout of your data table/range then you need to create a "helper table/range" where you ...

Hi Harold, I will be stuck with playing around with this later this evening. Thanks for the tip. /Anders

Hello Estella, First things first, the way the current formula is built we need to have the same amount of rows as the lookup range has, so by exte...