So this is what I did now, and it's working
1. Calculated field: not hidden at all
CASE WHEN [@field:Schedules_ACTIVE] = 1 AND [@field:Schedules_Enddate] < SysDateTime() THEN 'Code C' ELSE NULL END
2. Footer to change record background
<script>
document.addEventListener('DataPageReady', colorHandler);
function colorHandler() {
let lines = document.querySelectorAll("td:nth-child(5)"); // 5 is the column order number
lines.forEach(line => {
if(line.innerText.startsWith('Code C')){
line.parentElement.style.backgroundColor = '#FF5C45';
}
})
document.removeEventListener('DataPageReady', colorHandler);
}
</script>
Happy for now Thanks @Ilyrian and @CoopperBackpack