I can't figure this out… (about conditional formatting)

[Johnny Rosenberg]

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

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Brian Barker]

At 18:45 07/11/2009 +0100, 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?

Instead of using a formatting code in the cell style, set the font
colour to the same as the background colour?

I trust this helps.

Brian Barker


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Johnny Rosenberg]

2009/11/7 Brian Barker <b.m.barker@...>:

> At 18:45 07/11/2009 +0100, 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?
>
> Instead of using a formatting code in the cell style, set the font colour to
> the same as the background colour?

I have tried that and it works. That was the way I did this before I
tried the method that failed. But if I suddenly decide to change the
background colour of the whole sheet, I have to change the font colour
AND background colour of that new style(s) making the whole thing a
little less automatic…

But yes, it's definitely an option.

Johnny Rosenberg

>
> I trust this helps.
>
> Brian Barker
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@...
> For additional commands, e-mail: users-help@...
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[TomW-3]

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: users-unsubscribe@...
For additional commands, e-mail: users-help@...