May 22 2019 11:35 PM
May 22 2019 11:35 PM
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?
May 23 2019 12:38 AM
May 23 2019 02:35 AM
Solution@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.
May 23 2019 03:45 AM
Thank you sir, I already apply the conditional formatting. Thanks for you advise.
May 23 2019 03:51 AM
May 23 2019 02:35 AM
Solution@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.