Is you red colour applied manually or via conditional formatting? If it
is conditionally formatted, then the formula which applies it could be
entered into another column to return some value (like "R"). Then you
could apply a filter to that column looking for "R" and then copy your
google search formula from above only into the visible rows.

Hope this helps.

Pete