As Charles and I have both pointed out, you need to know exactly which shade of red is applied. The RGB values of a colour has 256 x 256 x 256 possible variations. There are probably over 10,000 various combinations that people might say are 'Red'. wdColorRed is only one particular variation of these possibilities.

Also, the code is written to be looking at the colour of the entire footnote. If there is variation inside the footnote such that there is more than one colour applied in the entire paragraph (potentially including the paragraph mark), then the colour would be undefined and therefore wouldn't be considered Red at all.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia