Conditional Formatting

patje

New Member
Joined
Jul 12, 2005
Messages
13
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.
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Watch MrExcel Video

Forum statistics

Threads
1,099,113
Messages
5,466,752
Members
406,496
Latest member
Arlind Elezi

This Week's Hot Topics

Top