Macro to clear only the contents of the cells which have a specific font colour

Hi and welcome to the forum.

The most efficient way would be to filter the list and then clear the contents. However there's no standard non VBA functionality that will filter by colour so the first question to ask is is there any other column which could be used for the filter. i.e. where there is a direct correlation between the value in the column and the colour in column B

Originally Posted by Stellakyp

unfortunately both colours exists in every cell, see bellow how it is:
i.e.

COCA-COLA
(MANAGING DIRECTOR)

How can I delete the black font content from the cell and leave only the blue one?

Were you intending to upload a workbook so that we can see the request in context. I don;t understand your statement that both colours exist in every cell. A cell can only have one background colour and one font colour, (leaving aside the special shading formats).

Your original mentioned column B, this last post says column B. Which one is it.

And can you show a before and after situation. i.e. manually add what you expect to see once a cell has been cleared.

Hi,

OK, Will the title in column A always commence with the opening parentheses ( ?
What about rows 11:13. Should these too also be split or deleted. And if deleted what's the rule to apply there since they have the same format as rows 3:6?