Conditionally format row based on hidden column

[sll1966]

When say column 3 has value of C i would like for format that row. Additionally, i would like to not display column 3.
Any help would be great!

`GetJobsData();

	//Get data using API
	window.setInterval(GetJobsData, 30000); // How often to get data 

	function GetJobsData() { 
		const reqJ = new XMLHttpRequest()
		reqJ.addEventListener("load", reqListenerJobs);
		reqJ.open("GET", '../../api/ProductionSchedule/{{{ParmLocation}}}/{{{ParmLine}}}');
		reqJ.send();
		
		function reqListenerJobs () {
			const result = JSON.parse(this.responseText);
			//console.log("api job result:" + JSON.stringify(result));
			const labels = [];
			let series = [];
			result.forEach(function(row){
				series.push([Object.values(Object.values(row))[0],
							Object.values(Object.values(row))[1],
							Object.values(Object.values(row))[2],
							Object.values(Object.values(row))[3]

							]);
			});
			document.getElementById("JobSchedule").innerHTML = '';
			const grid = new gridjs.Grid({
				columns: ['Seq', 'Item', 'Exception', 'Ord'],
				data: series
			}).render(document.getElementById("JobSchedule"));
			grid.on('rowClick', () => toggleCustomerNames() );
		}
	}	`

data :
Seq JDEItem FlashMessage QtyOrdered
1.00 500332610229 C 30
4.00 500332610288 C 3
9.00 500332610174 C 48
10.00 500931910258 C 50
11.00 500351910420 A 5
12.00 500351910432 A 14
14.00 500351910347 A 15
15.00 500332610168 A 2
16.00 500932610189 A 20
17.00 500931910371 A 370
18.00 500332610218 A 5
19.00 500351910479 A 100

[sll1966]

Possibly call a function like below i was writing, but not sure if that is the best solution and gridjs table doesn't have an ID. I could use getElementsByClassName but every table on page would be the same. Below is my current method that works (although doesn't highlight the whole row)

 function tablerowFormat(table,column,compare,value,ExtraClass) {
	console.log("tablerowFormat:" + table + ' ' + column + compare + value + ' ' + ExtraClass);
	document.getElementsByClassName(table)[0].id = 'TheTable';
	var rows = document.getElementById('TheTable').getElementsByTagName('tr');
	//console.log(rows[0]);
	//Find heading column in first row that matches parm
	for (var c = 0; c <= rows[0].children.length && rows[0].children[c].innerHTML.indexOf(column) === -1; c++);

	if (c > rows[0].children.length) {
		console.log('Column ' + column + ' was not found');
	} else {
		console.log('Column [' + column + '] found in ' + rows[0].children[c].innerHTML);
		//For each row if column value = or <> parm value, do some styling
		for (var r = 1; r < rows.length  &&  rows.length > 0; r++) {
			//console.log('looking at row ' + j + ' in column ' + i);
			if (compare === '=') {
				// must match value
				if (rows[r].children[c].innerHTML.indexOf(value) > -1) { 
					console.log('Got = at col ' + c + ' row ' + r );
					//rows[j].classList.add(ExtraClass);
					document.getElementById("TheTable").children[1].children[r-1].children[1].className = ' ' + ExtraClass;
					}
			} else {
				// must NOT match value
				if (rows[r].children[c].innerHTML.indexOf(value) = -1) { 
					console.log('Got <> at col ' + c + ' row ' + r );
					//document.getElementById("TheTable").children[1].nth-child(r).className = ' ' + ExtraClass;
					document.getElementById("TheTable").children[1].children[r-1].children[1].className = ' ' + ExtraClass;
				}
			}
		}
	}
};

Then in CSS using

.exception {
    background-color: #ffc107;
    color: black;
}

and calling
resultFormatting('GridJS','Exception','C','=','exception');