Skip Text marked with Defined color (Excel)

Hello people,

In SDL Studio you have got a filetype-setting for excel, also you can on the tab color select skip text marked with defined color".

I have written a VBA script  because we have got like 100 different excel-files where we got different criteria of cells that need to be hidden.

I used in VBA color.interiorindex to color certain cells.

Here is an example of the result:

Here is my SDL studios settings:

The red cells is still available for translation... why ? what is wrong

Do I need to specify RGB values in VBA instead of colorindex?

Could someone help me?

Thank you in advance