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