XL2BB on osx 10.15.3 catalina and Excel 365 16.29.1

[etaf]

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 ?

 

[smozgur]

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]

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]

You need to install it as an Excel Add-in.
Tools -> Excel Add-ins.

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).

 

[etaf]

ok, did that

CONDITIONAL-etaf.xlsx
	A	B	C
1	Trial	Sequence	Order
2	acorn	1	1
3	acorn	2	2
4	acorn	3	3
5	acorn	4	4
6	admirer	1	1
7	admirer	2	2
8	admirer	3	3
9	admirer	-	4
10	affinity	1	1
11	affinity	2	2
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A62000	Expression	=TEXTJOIN(,,OFFSET($B$2,INT((ROW($B1)-1)/4)*4,,4))="123-"	text	NO
A2:A62000	Expression	=TEXTJOIN(,,OFFSET($B$2,INT((ROW($B1)-1)/4)*4,,4))="1234"	text	NO
A2:A62000	Expression	=A2<>""	text	NO

 

[etaf]

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
	A	B	C	D
1	Trial	Sequence	Order
2	acorn	1	1	0
3	acorn	2	2	0
4	acorn	3	3	0
5	acorn	4	4	0
6	admirer	1	1	0
7	admirer	2	2	0
8	admirer	3	3	0
Sheet1

Cell Formulas
Range	Formula
D2:D8	D2	=IF(A2="1",1,0)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A62000	Expression	=TEXTJOIN(,,OFFSET($B$2,INT((ROW($B1)-1)/4)*4,,4))="123-"	text	NO
A2:A62000	Expression	=TEXTJOIN(,,OFFSET($B$2,INT((ROW($B1)-1)/4)*4,,4))="1234"	text	NO
A2:A62000	Expression	=A2<>""	text	NO

 

[smozgur]

You're welcome.
Glad to hear it works.

 

[etaf]

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