Sometimes I encounter excel sheets, which have been created with colour annotations.
Given a set of variables and observations an extra layer is added manually by adding colour codes to each cell, where the colours are independent of the values in the sheet.
Is it possible in a tidy way to extract these additional annotations? I have found some online examples here and here, but they are not tidy
Perhaps in a long format, something along the lines of
column row value annotation
A 1 2 red
A 2 1 yellow
A 3 0 white
...