EXCEL for MAC version 16.35 has a conditional formatting bug
Conditional formatting which uses named ranges in the condition, can't be copied between two workbooks. It can be copied only within one workbook.
Identical conditional formatting that uses unnamed ranges can be copied between workbooks without a problem.
This bug is in versions 16.35 and 16.37.
Vlad Shargorodskiy commented
It is also in version 16.36.
Dear Micro and Soft! Please fix it!