Johnny Rosenberg wrote:
Create a new style. Call it ”Invisible” and enter "" in the formatting
code field.
Select column A except A1. Make sure A2 is the selected cell of that range.
Conditional formatting → Cell value is → A1 → Style: Invisible → Click OK.
Enter todays date in A2 and A3 and then Tomorrow's date in A4. A3 will
now look empty. Works great.
But enter text in those cells! No matter what you type, no cells will
look empty!
I tried all the workaround that I could think of, including Cell
protection → Hide, nothing works.
Is this even possible to do?
For example, if I input the followong in column A:
This
is
is
interesting
The result of this should look like this:
This
is
interesting
Anyone?
Regards
Johnny Rosenberg
Johnny:
The 'formatting code field' is a number formatting function. The 'Text'
format option is for pre-defining a cell so that a number is treated as
text.
TomW
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
