Excel help required?

Copper Contributor

I am trying to get all RED text only from one worksheet to appear automatically in a separate worksheet in a single cell. Does anyone out there know how I can do this on Excel 2010??

1 Reply

@simonWolf Colour is not data. Excel formulas cannot identify the colour used for fill or font of a cell.

 

Can you post a small data sample in an Excel file and explain in context?