XL2BB on osx 10.15.3 catalina and Excel 365 16.29.1

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
8,191
Office Version
  1. 365
Platform
  1. 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 ?
 
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?
 
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
 
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
 
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
 
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
 
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
 

Forum statistics

Threads
1,213,531
Messages
6,114,172
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top