Conditional Formatting -When applying Blank Cells

[Nandakumar]

Hi,

I applied conditional formatting when cells are blanks.For some merged cells formatting is not applying.Attached sheet for your reference.
In this sheet,conditional formatting is not applying for row M4,N4,P4,Q4,S4,T4,V4,W4.

Can you please help.

 

[NARAYANK991]

Hi ,

Can you explain what you want done ?

Narayan

 

[Nandakumar]

Hi,

I created conditional formatting where cell is blank remove the table and fill the cells in white colours.When i drop down total all data will flow and table need to be shown.But as mentioned above,in some rows though i selected total,complete line format is not applying in M4,N4 etc..

Hope you understand

 

[NARAYANK991]

Hi ,

I am sorry , but I am not able to understand.

Your worksheet has formulae in the range C4:U4 ; can you explain what the Conditional Formatting should do ?

Narayan

 

[Nandakumar]

Hi,

From C4 to W5,when there is no value or it is Blank,i need to conditional format with filling white colour and removing border lines.

But when i reselected the TOTAL in dropdown,border line for rows should appear.if you look at L4,line is appearing but not for M4.

I hope now you understand

Thanks

 

[NARAYANK991]

Hi ,

See if this is what you wanted.

Narayan

 

[Nandakumar]

Yes.It works perfect.Thank you.

Can i know where i went wrong?

 

[NARAYANK991]

Hi ,

I have applied the CF rule to each individual block ; you can see them for yourself by selecting the range C4:W5 and clicking on Manage Rules.

Narayan

 

[Nandakumar]

OK.Thank you