Hey guys,

Do anyone know how to overcome Excel 2016's 32768th row barrier? I am using macro and trying to filter cells/rows with background colour. My formula should return true or false but after 32768th row it is returning #NUM!. I have at least 100,000 rows in my spreadsheet.

Thanks!