Dear all,
For an work sheet I want to set the following conditional format.
When a cell shows a specific number then the whole tekst in another cell must become white or invisible.
When I set this conditional format, only a part of the tekst in the specified cell turns white or invisible. The normal tekst turns white, but in the text used symbols (like Δ and ε) and the text in superscript or subscript mode stay black.
How can I get the whole tekst shown in a different colour for the specific value of a cell?
Maybe there is an other possible way than using the option "conditional formatting"?
Kind regards.
For an work sheet I want to set the following conditional format.
When a cell shows a specific number then the whole tekst in another cell must become white or invisible.
When I set this conditional format, only a part of the tekst in the specified cell turns white or invisible. The normal tekst turns white, but in the text used symbols (like Δ and ε) and the text in superscript or subscript mode stay black.
How can I get the whole tekst shown in a different colour for the specific value of a cell?
Maybe there is an other possible way than using the option "conditional formatting"?
Kind regards.