Forum Discussion

Deleted

Not applicable

May 22, 2019

Solved

Excel formula Help

Hi, I need hide the column D7; to D37 In window 10 which the data no entry from B7 to B37. I can hide whole column but I cant hide the which I need not shown when no entry at column B. How do I can make it hide?

Schedule waste record 2019.xlsx58 KB

Formulas and Functions

SergeiBaklan
May 23, 2019
Deleted , as workaround you may apply conditional formatting - if nothing in B apply same font and cell color (e.g. grey one) in D, otherwise no such formatting.

5 Replies

SergeiBaklan
Diamond Contributor
May 23, 2019
Deleted , as workaround you may apply conditional formatting - if nothing in B apply same font and cell color (e.g. grey one) in D, otherwise no such formatting.
- Deleted
  Not applicable
  May 23, 2019
  Thank you sir, I already apply the conditional formatting. Thanks for you advise.
  - SergeiBaklan
    Diamond Contributor
    May 23, 2019
    Deleted , you are welcome
JKPieterse
Silver Contributor
May 23, 2019
You cannot hide just a square set of cells within one column or row. Why do you want to do this?
- Deleted
  Not applicable
  May 23, 2019
  Original worksheet I will keep, but for manual record I need to pass to the production line. they will write the record. The day they record, balance will calculate by their self. that why I need hide the D records.