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

  Sean.f 11:55 13 Jun 2010
Locked

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.

Thanks

Sean

  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

sorted.

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

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone