Excel Colour

Hi,

I am trying to create a summary table with two coloumns that will be populated with a brand name / date.

To get the brand names / dates this will be based off if another cell in the table is red. Is there a way to search if a cell is red then return the brand name / date from another cell based on if it is? Whilst also not returning any results for the cells that didn't meet the criteria so I don't have blank cells in the summary.

Thanks for any help :)