Conditional Format Using Formula By Referring To Another Sheet

[paul_pearson]

Hi

I need help setting up Conditional Formatting please. For Sheet 2 Cell B2 how can It reference Sheet 1 cells C7:P7 and then through Conditional Format colour Sheet 2 cell B2 either White,Yellow,Red or Green

1. If the cells C7:P7 has a "G" it is worth 2 points , if the cells has a "S" the cell is worth 1 point & empty cell is worth 0 points...
2. If C7:P7 points total <4 points the Sheet 2 cell B2 colour is White , If C7:P7 points total between 5 and 8 points the Sheet 2 cell B2 colour is Yellow , If C7:P7 points total 9 and 12 points the Sheet 2 cell B2 colour is Red and If C7:P7 points total >13 points the Sheet 2 cell B2 colour is Green

How can I have a Conditional Format system for Sheet 2 Cell B2 which looks at Sheet 1 and totals the points from C7:P7 and then colours according to points

Thanks

Excel 2010