Compare Cell Values when edit is complete ?
Compare Cell Values when edit is complete ?
My table has 5 columns and multiple rows.
Currently as I read the data from a database and then write it to screen, I check if the value of 2 variables about to be written into the rows cells match, if they don't I change the background color of 3 cells on the same row.
This process can lead to multiple rows with highlighted cells.
If I then edit one of the cells, so the 2 values on the row do match, I have to refresh the page to remove that rows cells background color.
Is there anyway when I have edited one of the cells to have it automatically check the other to see if the values match and if they do then remove the background color from all 3 cells...
The columnID's are 0, 3 & 5. I'm checking on a row values in columns 3 & 5.
I think that makes sense...
Currently as I read the data from a database and then write it to screen, I check if the value of 2 variables about to be written into the rows cells match, if they don't I change the background color of 3 cells on the same row.
This process can lead to multiple rows with highlighted cells.
If I then edit one of the cells, so the 2 values on the row do match, I have to refresh the page to remove that rows cells background color.
Is there anyway when I have edited one of the cells to have it automatically check the other to see if the values match and if they do then remove the background color from all 3 cells...
The columnID's are 0, 3 & 5. I'm checking on a row values in columns 3 & 5.
I think that makes sense...
This discussion has been closed.
Replies
Allan