MarvinP,

I have noticed however that if the user corrects an incorrect selection from the dropdowmns, then the comments will revert back to black! So it kinda works then because a user should not be leaving their spreadsheet with incorrect selections (thats the whole idea of why Ive done this).

It's still odd why the Comments column changes to red under these circumstances because I have not and do not wish to apply any formatting in that column

Thanks again - I appreciate you guys taking a look