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

[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 (A914), 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 A1112

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

Thanks alot!

Regards

 

[Claus Busch]

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 (A914), 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 A1112

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