Coloring Cells Error In Reports

Frappe Framework Customization
1

Hello,
I’ve colored cells in Employee Leave Balance Report.
but i’ve write code to color 2 columns on different conditions but it is only showing color on one column.

My Code is :

"formatter":function (row, cell, value, columnDef, dataContext, default_formatter) 
{
  value = default_formatter(row, cell, value, columnDef, dataContext);
value1 = default_formatter(row, cell, value, columnDef, dataContext);
	
        if (columnDef.id == "Casual Leave Taken") 
		{
             if(dataContext["Casual Leave Taken"]<5)
             {
               value = "<span style='color:red!important;font-weight:bold;'>" + value + "</span>";
             }
			
		}
	    if (columnDef.id == "Casual Leave Balance") 
		{
			if(dataContext["Casual Leave Balance"]<20)
			{
			value1 = "<span style='color:green!important;font-weight:bold;'>" + value1 + "</span>";
			}
			
        }

   return value;
	return value1;
}

Result Is :
Capture

Please advise where i am doing mistake.
Thanks.

2

@shahid you could not define

return value;
return value1;

Because it’s not an generator function, when the code, reach the first return it just go out of the function, so, the value1 will never be returned!

My suggestion, rename, value1 to value it should work and remove the additional return.

3

Thank you so much @max_morais_dmm.
Its working.