MATCH STRING IN A COLUMN AND RETURN ALL ROWS (entire row) THAT MATCH THE STRING

Dear Team Members,

Hope you are all doing well.


I need some help with regards to my excel file. (Sample file attached)

I have an array containing data into rows and columns.
I want to search for a string in one of the columns (Lets say the first column)
For eg : In the attached file, I have shown the search text as "red"

I want the formula to search in the entire column for the string "red" and return the entire row as outputs.

So If "red" appears 5 times .. it should return all those 5 rows where the text "red" appears.

I have shown the desired output as well in my excel file.

Please help !!