Bob, thanks for your reply....your reply didn't answer my question completely as I was left wondering what to do after I got into the conditional formatting part, which, through trial and error, and guessing, eventually led me to what I wanted to achieve....
Thanks for your reply.