Select Cell Content from Range of Cells Based on Text Formatting Criteria

[PKT]

Hi,
I have a range of cells (A2:A5) with text. Of these range of cells, there is always ONE cell that has specific formatting (e.g. RED text, BOLD text, colored BACKGROUND, etc.).The text formatting varies based on the row. All other cells within this range on that specific ROW has black text.
I need to get the content of the cell that has the FORMATTED text and store it in cell A1.
Is there a function or formula that can do this in Excel? Thanks.

A1	A2	A3	A4	A5
strawberry	apple	orange	banana	strawberry
football	baseball	football	basketball	soccer

A1	A2	A3	A4	A5
strawberry	apple	orange	banana	strawberry
football	baseball	football	basketball	soccer

A1	A2	A3	A4	A5
strawberry	apple	orange	banana	strawberry
football	baseball	football	basketball	soccer

 

[Fluff]

Duplicate to: Selecting Cell Content Among Range of Cells Based on Text Format (e.g. Red Text or Yellow Background)

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.