how do I hide an excell cell until data is added?

  Sean.f 11:55 13 Jun 2010

Hello I want cell U2 with =(52-T2)/52 to be blank until data is added to to T2 cell at the moment it shows 100%. I can then copy rhis to the other 300 cells.



  Eric10 12:05 13 Jun 2010

Try IF(ISBLANK(T2),"",(52-T2)/52)

  Eric10 12:09 13 Jun 2010

I omitted the equal sign "=" in front of the formula so it should actually be =IF(ISBLANK(T2),"",(52-T2)/52)

  Sean.f 12:22 13 Jun 2010

Thanks Eric10 for the help. The sheet looks a lot better now.

  Sean.f 10:23 14 Jun 2010

One more question. Is it possible to have the cell automatically change colour if say the sum is less than 50%?

  Sean.f 10:29 14 Jun 2010


This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

The art of 'British' pulp fiction

Best password managers for Mac

TV & streaming : comment regarder le Tournoi des Six Nations 2018 ?