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