Q1) want column border as per my wish, as i want it in 2-2-3-1 ratio.not as per column banding,
Q2) color background cell even for null cells
You can change the 'level' at which a column border applies, try moving it up a notch.
I don't know how your coloring your normal cells so I can't advise how you would color the nulls. You need to provide a packaged workbook.
Retrieving data ...