Forum

Hi MM. Excel uses its own internal names for the sheets e.g. Sheet1, Sheet2. If you change the names on the sheet tabs in your workbook, these int...

Sorry, Access is not my strong point so I'm not sure what to suggest to make it work for you. Regards Phil

Hi Robert, The formula you need to make the text red under those conditions is: =AND(B2=TRUE,OR(RIGHT(A2,3)=".wa",RIGHT(A2,3)=".oa",RIGHT(A2,3...

Hi Maurizio, Give this a go. Regards Phil

Hi Robert, The syntax for OR is =OR(Condition1, Condition2) so something like =OR(A1=123, B1="xyz") Your first OR formula is OR($A2,A2="wa") ...

no worries

no worries. 🙂

Thanks Adrian. Yes you can attach the workbook (or sheet). Do you want it sent as an Excel file or as a PDF? Phil

Hi Bala, See attached. The formula in Col J is an array formula that you will need to enter with CTRL+SHIFT+ENTER but does the job: =MATCH(MIN(...

Hi Mike, Running the MyTimer code above shouldn't trigger calculation. hmmmm. Not knowing what you are doing in these workbooks, but judging by...

Hi Steve, I can't see why your code would run any differently on 2019 or 365. Phil

Hi, Do you have XLOOKUP? If so you can use this: =XLOOKUP(G3,$E$3:$E$22,$A$3:$A$22,,1) See the attached workbook. Regards Phil

Hi Ish, Did you follow the link to this post on Conditional Formatting which will answer your questions? Regards Phil

Hi Mike, Without seeing your code I can only guess as to what you are doing. But if you use this Sub then you should be able to work out the tim...