No. Colour is not data. That's why people have developed VBA routines.

You can filter by colour and SUBTOTAL will exclude hidden row so you could maybe use that as a workaround.

Regards, TMS