Last seen: Aug 30, 2025
Hello, It is always easier if we can see the data, a small sample file is good enough.
Hello, With this approach you need a VBA solution. Coloured cells is nothing you can check for and use as values/conditions in formulas. You find m...
Hello, More info here about the TODAY function. Change your formula to =IF(M2-TODAY()<0,””,M2-TODAY()&” days”) and it will work. You can ...
Hello, That is a lot of conditional formatting rules you have in your workbook. It seems to me that you know how to set up such rule you want help ...
Hello, I also found this blog article that covers this topic.
Hello, Sorry, but no file is attached. Seems to me that you want to do something like this.
Hello, The INDEX function has following syntax: INDEX(array, row_num, [column_num]) Your formula is wrong as you are trying to find the column_n...
Hello, What FIND function gives you is the character position number if it finds what is looked for, else a #VALUE! error. By wrapping this with th...
Hello; There is a guide you can check out at
Hello Alan, Just providing a link to some more information about conditional formatting using formulas.
Hello, What kind of issue do you have when running the code? Is it what Philip writes in his article? "The big drawback of using Wait or Sleep, ...
Hello, I do recommend you to check out the blog section, there are great articles to be found there.
Hello, Have you tried using Power Query? Here is a good article how to use VBA to get data from web pages.
Hello, I am not clear with what you want help with, I don't see any formulas in your attached file.
Hello, That is correct, as you have ProPlus version you have an enterprise product, so the setting for Office Insider is available for the administ...