My pivot table some row display white , How to make whole table in one color ?

[paulyeo11]

Hi All

My pivot Table when 1st column have not data , the whole row will be white. this make the table look not perfect. Hope some one can advise me how to make whole table white or yellow ?

[marcus_malinow]

If you right-click the white cell, and select custom format. Then change it to yellow like the others.

See attached.

[buzzy996 · Accepted solution]

see below,tht;s causing issue.

[paulyeo11]

Hi Marcus

After looking at your solution , i like it , and i think it is better solution , as i still can keep my old code which will be use for other none pivot table.

Thank you for your help.

Paul