How can I exclude red TEXT (not cells) from the word count, but retain it in the final translation?

Question

Hi all, Despite some bedtime reading efforts, I aseem to best stuck. SITUATION: I received an Excel file with some but not all text in red in some cells. (Please re-read). REQUIREMENT: Text in red should be left untouched (i.e. NOT be translated, nor counted) but MUST appear in the resulting translation. APPROACH: Before entering the file into my Trados Studio 2022 project, I go to File types, then Microsoft Excel 2007-2019 , then Content processing, FINDINGS: Trados 2022 only seems to allow me to "Skip cells having the selected text colour", seemingly referring to ALL text in one cell.This is not what I need. WISH: I am in need of an option such as "Skip TEXT colour having the selected text" QUESTION: HOW CAN I SOLVE THIS? Any help would be greatly appreciated. TIAFYA. 
 Regards, 
 Matthew VAN HOORN VVH business translations

Jesús Prieto · Answer

VVH business translations 
 I don't think you can do that in Trados Studio. 
 I think you need to prepare the files before start translating in Studio. For example, copy the cells an dpaste them to a an empty Word document, select all the red colour text and set is a hidden (a replace all in Word). Translate that document as usual (Trados Studio will skip hidden text), then create the translated Word document, open it in Word, select all text and unhide it, and finally copy-paste it back into Excel. I think it should be ok, but test it a bit beforehand.

Trados Studio > 1. Trados Studio

How can I exclude red TEXT (not cells) from the word count, but retain it in the final translation?