Pull Data From One Sheet to Another Based on Cell Font Colour

[JayR22]

Hi all,

Hoping someone can help.

I've attached a workbook that may explain my problem a little easier.

I want to display certain cells on a front sheet that are retrieved from another sheet in the same workbook, based on the colour of the font in the cell from the source (the conditionally formatted font). Is this possible?

As the source data changes weekly, I want the front sheet to automatically update with the new cells that now contain red text from the conditional formatting.

Thanks in advance.

[Glenn Kennedy]

If the colouring is applied manually, there is no good, easy way to do that. However, in your case, it was applied by conditional formatting, so it is easy:

=FILTER(Data!A2:B40,Data!C2:C40="Yes")