Forum Discussion

simonWolf's avatar
simonWolf
Copper Contributor
Jul 07, 2019

Excel help required?

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?

Resources