I’m using an If in this form:
cint(row(“Total”).ToString) < CInt(row(“0”).ToString)
I’m using an If in this form:
cint(row(“Total”).ToString) < CInt(row(“0”).ToString)
U can use if condition like this
Cint(row(“Total”))<0
Regards
Nived N
Happy Automation
A tricky one but may help just try once
I’m getting an error because the column is double, the if is because If the value is negative I want to set a color in that cell
I was using For each row also, using just the If is better thanks
Did u check using below condition
CDbl(row(“Total”))<0
Sort DataTable by “Total” col and check the first row.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.