I have a program with a listbox. In this listbox, there are many cells. I would like to change the forecolor of cell 2,3 and 4 based on the content of cell 12. I tried with the event CellTextPaint but I could only paint the whole row. Here's the the first code:
If me.Cell(row,20) <> "" then
g.ForeColor = &c0000FF
I was able to change the forecolor of a specific cell based on its content using this:
If me.Cell(row,Column) = "Annuel" then
g.ForeColor = &cFF8000
So far, I was not able to change the forecolor of a specific cell based on another.
Could anyone help with me this puzzle please?