XL2BB on osx 10.15.3 catalina and Excel 365 16.29.1

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
3,779
Office Version
365
Platform
MacOS
I cannot get
XL2BB to work on my macbook

osx 10.15.3 catalina and Excel 365 16.29.1

tried a few weeks ago

does XL2BB work on OSX versions of excel ?
 

Some videos you may like

smozgur

BatCoder
Joined
Feb 28, 2002
Messages
933
XL2BB works with Excel 365 on OS X since its initial release.
In fact, most part of the add-in has been developed in OS X (except userform design since it is not possible in Mac).

What is the problem you are experiencing?
 

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
3,779
Office Version
365
Platform
MacOS
install it is the first issue
goto insert > get addins
then cannot see how to load the xl2bb.xlam, from the downloads extracted zip file
 

smozgur

BatCoder
Joined
Feb 28, 2002
Messages
933
You need to install it as an Excel Add-in.
Tools -> Excel Add-ins.

excel-addin.jpg


Then click Browse and find the xl2bb.xlam add-in file to install as Excel Add-in (it is installed in my computer, so it is in the list already. You'll have it in the list as soon as you install it).
1584474271819.png
 

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
3,779
Office Version
365
Platform
MacOS
ok, did that
CONDITIONAL-etaf.xlsx
ABC
1TrialSequenceOrder
2acorn11
3acorn22
4acorn33
5acorn44
6admirer11
7admirer22
8admirer33
9admirer-4
10affinity11
11affinity22
Sheet1
Cells with Conditional Formatting
CellConditionCell FormatStop If True
A2:A62000Expression=TEXTJOIN(,,OFFSET($B$2,INT((ROW($B1)-1)/4)*4,,4))="123-"textNO
A2:A62000Expression=TEXTJOIN(,,OFFSET($B$2,INT((ROW($B1)-1)/4)*4,,4))="1234"textNO
A2:A62000Expression=A2<>""textNO
 

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
3,779
Office Version
365
Platform
MacOS
thanks - didnt work last time , sure i also tried that before, maybe NOT
anyway - seems to have worked
thanks

test for formula too
CONDITIONAL-etaf.xlsx
ABCD
1TrialSequenceOrder
2acorn110
3acorn220
4acorn330
5acorn440
6admirer110
7admirer220
8admirer330
Sheet1
Cell Formulas
RangeFormula
D2:D8D2=IF(A2="1",1,0)
Cells with Conditional Formatting
CellConditionCell FormatStop If True
A2:A62000Expression=TEXTJOIN(,,OFFSET($B$2,INT((ROW($B1)-1)/4)*4,,4))="123-"textNO
A2:A62000Expression=TEXTJOIN(,,OFFSET($B$2,INT((ROW($B1)-1)/4)*4,,4))="1234"textNO
A2:A62000Expression=A2<>""textNO
 

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
3,779
Office Version
365
Platform
MacOS
Cool, thanks so much , saves putting things on dropbox and then when i delete the file. lost from the post in history and searches - so will try an use more often

thanks so much
 

Watch MrExcel Video

Forum statistics

Threads
1,095,726
Messages
5,446,154
Members
405,387
Latest member
michmichmich2020

This Week's Hot Topics

Top