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??
@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?