This is the original table named as COLOR
COLOR
ID----BLUE---RED---YELLOW
111---X--------------------
222-------------X--------X
333---X--------------------
444-------------------------
I need a loop to check above table cell by cell and then update another table.
The final result is table named as ISCOLOR
For example, after looping, ISCOLOR table should be updated as below.
ID---ISCOLOR
111--YES
222--YES
333--YES
444--NO