Rather making the cell border color "paper" you can choose "NONE" , which is gonna work like transparent with the same weight 1mm.

yes, you are right Peter but in OP

              "  So what I need is a way to make the cell borders transparent but retain the 1mm transparent gap between every cell, some of which are also transparent and most have a solid fill."

some cells are  transparent  and most have a solid fill...hence all cells are not transparent....also he has asked for the make the cell borders transparent which have the 1mm weight.,

changing the cell border color to NONE will make it transparent and will give the 1mm gap in the cells , also it will allow to see the picture behind the table (only the part which is not blocked by table) .

Are you applying the dashed stoke on the cell border , to create the Gap in the stroke itself and then changing the color of cell border to NONE?

If yes , why to do so because in OP he has asked to " retain the 1mm transparent gap between every cell "

May I know your workflow ,,?

Where do you see any mention of a dashed stroke style? My interpretation is there is a solid border around the cells leaving a "gap" or "cell spacing" of 1 mm. Currently the stoke is [Paper], some cells have a tinted fill, and some a paper fill, so it might look something like this:

And the goal is to have all the parts that are currently [Paper] changed to allow the blue background (in my example) to show through. Not a problem for the cell fill -- changing that to [None] works, but ther is no way that I've found to have a solid transparent 1 mm gap between cells in place of that white gap without adding rows and columns and filling them with [None].

If you know a way to make those solid white lines transparent, I know a lot of users would love to hear it.

You are right.as always....When I intially did I was successful but now I am not able to do it ...may be first time I missed something and jump to the conclusion ......sorry for the mess.

LESSON LEARNED thanks a ton PETER....

I have 2 but I think it would be least bit helpful here because table is aleady been created but lets see...

Method one:-

Make the Rectangle and then use the script "Make Grid" , put the gutter space as 1mm , and rows and cloums equal to what is required in the table.

Copy and paste the content from the table to the text boxes created from the script.

Method two(will work if solid fill is done in few cells only):-

Select the complete table , under "cell options" change the "cell fill" to "None"

complete table shall be selected , under "cell options" , apply the stroke type "thin-thin" with "6 pt" with the "gap color" :- NONE and stroke color "Black"

also change the "cell inset" to "0 mm"

now de-select the table ,

select any one cell on which you want to apply the solid fill and follow the below step:-

   a) Table-->Insert table , row 1 and column 1

   b) re-size embedded table according to the cell size

   c) Fill the color in the embedded table in the cell

After this copy and paste this in all cell in which you want the solid fill.

again in this text will be the problem when copying and pasting the embedded table.

Hint:- steps taken from Indesignsecrets.com

====================================================================== =====================