Hide rows in table based on 1 empty cel of the same row.

  • Thread starter Thread starter jellelurquin
  • Start date Start date
J

jellelurquin

Hi guys,

I can probably solve this with conditional formatting, but I'm not sure how so I was wondering:

I have a table with 6 rows , 4 columns (A9:D14), I was wondering if there is a way to hide the rows 11 and 12 when B11 and B12 are empty (in C11,C12,D11 and D12 is text)

So : B11&B12="" => hide A11:D12

Note : there is another table with data in it in G12 (so I cannot say : hide the full row 12)

Thanks alot!

Regards
 
Hi,

Am Tue, 9 Apr 2013 05:18:38 -0700 (PDT) schrieb (e-mail address removed):
I have a table with 6 rows , 4 columns (A9:D14), I was wondering if there is a way to hide the rows 11 and 12 when B11 and B12 are empty (in C11,C12,D11 and D12 is text)

So : B11&B12="" => hide A11:D12

Note : there is another table with data in it in G12 (so I cannot say : hide the full row 12)

you can't hide a range, you only can hide rows or columns.
You can use conditional formatting to turn font color to white.


Regards
Claus Busch
 
Back
Top