Conditional Format Using Formula By Referring To Another Sheet

[paul_pearson]

Hi

I am not sure if the following is possible

1. Sheet 1 has the operators names with each category either a "G","S"," ". If I enter 1 of these names in Sheet 2 Cell B2 can it then look at the persons name from Sheet 1 and fill in each category with a colour depending on how many points for each category. Currently fills colour using CF for each category
2. Can this be done with formula or does this need to be done with VBA

Thanks

Paul