Colour bound to data not row number ?

[Patrick <patrick spellingbeewinnars org>]

Hello Everyone

If I highlight FOO in row 3 red, I would still like it to be red after I 
sort and it is in row 5. However right now row 3 remains red but FOO is 
no longer there. It seems that the colour is bound to the row and not 
the data. Is there a way to keep the colour associated with the data?

Thanks for reading-Patrick