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: [email protected]
For additional commands, e-mail: [email protected]
