Yes you can write  VBA code to check on the colours in cells and then do
whatever you like with them.

When you filter  data, you can use the count facility in the status bar to
tell you how many items there are.