Last seen: Jun 10, 2026
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. 🙂
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...
Hi Steve, I can't reproduce the error. When I run VisibleTrue it runs without issue. Do you get this error when you open the workbook? What ...
You're welcome 🙂