Need script to find range of numbers in Indesign table

Hi together,

seems that somwhow this thread is related:

Is it possible to write a script in InDesign to do conditional formatting in table cells?
danielleg87395190, Aug 14, 2019

https://community.adobe.com/t5/InDesign/Is-it-possible-to-write-a-script-in-InDesign-to-do-conditional/m-p/10574246#M150783

Regards,
Uwe Laubender

( ACP )

Hi Sunil,

Your code has number of issues, i have fixed them and i am also listing below the issues

• You were iterating over tables and cells collection, which is fine but inside the loop body you were not accessing the objects using the index operator and hence was calling methods and properties on the tables and cell collection when you had to call them on table and cell instances. So you should have written tables[i] and cells[c] in the loop body
• You used parseInt on a decimal value, you should use pareFloat
• Even though it works but i would suggest never to check floating point numbers using an equality operator
• You created color and stored them in var named green, red, white but when using these colors you used Blue, Red, Green which are obviously undefined

app.doScript(main, ScriptLanguage.JAVASCRIPT, undefined, UndoModes.ENTIRE_SCRIPT, "Conditional cell formatting"); function main() 
{
	sel = app.selection[0];
	if (sel.constructor.name != "TextFrame")
	{
		alert("Please select the textframe that contains the table.");
		exit();
	}

	// create color swatches
	var blue = swatchCreator("Blue", [100,88,0,14]);
	var red = swatchCreator("Red", [0,100,2,0]);
	var green = swatchCreator("Green", [76,0,38,0]);
	tables = sel.tables;
	for (var i = 0; i < tables.length; i++)
	{
		var cells = tables[i].cells;
		for (var c = 0; c < cells.length; c++)
		{
			var cellValue = parseFloat(cells[c].texts[0].contents);
			if (cellValue <= 0.29)
			{
				cells[c].fillColor = blue;
				continue;
			}
			if (cellValue >= 0.30 && cellValue <=0.69)
			{
				cells[c].fillColor = red;
				continue;
			}

			if (cellValue > 1.00)
			{
				cells[c].fillColor = green;
			}
		}
	}
}

function swatchCreator(colorname, values) 
{
	var swatch = app.activeDocument.colors.item(colorname);
	if (!swatch.isValid)
	{
		swatch = app.activeDocument.colors.add({
		name: colorname,
		model: ColorModel.PROCESS,
		space: ColorSpace.CMYK,
		colorValue: values
		});
	}
	return swatch;
}

Also look into using the findchangelist script, or using the find change functionality of InDesign to solve this, it would be more easy and less or no code would be needed

https://helpx.adobe.com/indesign/using/find-change.html

-Manan