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

  Sean.f 11:55 13 Jun 10
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 10

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

  Eric10 12:09 13 Jun 10

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 10

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

  Sean.f 10:23 14 Jun 10

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 10

sorted.

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

Intel Coffee Lake 8th-gen Core processors release date rumours

1995-2015: How technology has changed the world in 20 years

Framestore’s haunting post-WWII title sequence for new BBC series SS-GB

Best iPhone games 2017 | Best iPad games 2017: 162 fantastic iOS games that you need to play right…