2009/11/7 Brian Barker <[email protected]>: > 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: [email protected] > For additional commands, e-mail: [email protected] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
