auto change font colour of a row when using dropdown

Hi FDibbins,

Thanks for your reply, I am using 2007 (I forgot to change that on my profile :s) does that mean I'm still limited to ref the same sheet?

Thanks Jeff