I'm working on a worksheet where data is segmented into groups of different number of rows separated with one empty row.

ColD has text data, where each cell's string has parts of red and black colours .. both are in the same one cell.

I need to swap colours per each cell, so the red portion becomes black, and the black portion becomes red.

Can I get some precious help with this quesion please?

Many thanks in advance.

T.