Change fill color based on content

Hi @rob day 

many many thanks for your help!

I managed to assign a fill color to the text frame.

Plus, I managed to assign the same color to the included text, which is useless to keep readable.

I just tweaked your code as follows:

var d = app.activeDocument
//var c = d.stories.everyItem().tables[0].columns[2].cells.everyItem().getElements();
var c = d.textFrames.everyItem().getElements();

var fc, cv, cn;
var ca= []
for (var i = 0; i < c.length; i++){
    cn = c[i].lines; // change color of the included text
    cv = c[i].contents.split(",");
    for (var n = 0; n < cv.length; n++){
        ca.push(Number(cv[n]))
    };

    if (ca.length == 3) {
        fc = makeSwatch(d, ca.toString())
        fc.properties = {space:ColorSpace.RGB, model:ColorModel.PROCESS, colorValue:ca}
        c[i].fillColor = fc;
    } 
    if (ca.length == 4) {
        fc = makeSwatch(d, ca.toString())
        fc.properties = {space:ColorSpace.CMYK, model:ColorModel.PROCESS, colorValue:ca}
        c[i].fillColor = fc;
    } 
    ca = [];

    for(var w = 0; w < cn.length; w++) {
        cn[w].fillColor = fc;
    }
};   


/**
* Makes a new named Swatch 
* @ param the document to add the color to 
* @ param color name 
* @ return the new swatch 
*/

function makeSwatch(d, n){
    if (d.colors.itemByName(n).isValid) {
        return d.colors.itemByName(n);
    } else {
        return d.colors.add({name:n});
    }
}

My last concern is: how can I change the background fill color (and the included text color) of a specific textframe?

If I'm not wrong, in your case, you pointed out every cell of the third column of a table; in my case, I'd like to select a specific textframe. 

So, rather than use

var c = d.textFrames.everyItem().getElements();

which might be catching all the textFrames in the document, I'd like to run the script just for a specific one.

I tried alternatively unsuccessfully to use this:

var c = d.textFrames.itemByName("test");
cn = d.contents;

but... it won't work and it makes useless the for loop. I got an error by Indesign.

Hi guys, thanks for your reply.

I can import RGB or CMYK value like 255,255,255 or 0,0,0,100 - I would rather import those values from csv, so no problem.

Attached an example.

Techincally speaking, I am not a developer and I'm sorry because I cannot write a working script.

I assumed it is possible to start from a basic concept like this and working on something like this one.

I sneaked peak into this link to understand a bit object, method, properties, and it seems feasible.

I was wondering if I'm the only one in need for this matter.