I have a column with value numbers, I want to make a rule, If the values on column 9 are equal or less than 0, so change color in “red”.
For this, I’m using this, It works, but when I resize the table, it colors the entire column:
if Column = 9 then
if Val(me.Cell(Row, Column)) <= 0 then
g.ForeColor = rgb(255,0,0)
else g.ForeColor = &c000000 end
What Am I doing wrong?