Open sheet 2 - Select the range to format ( say C3:AA4)
Select the Home Tab - Cond Formatting - manage rules
Click New rule - Use a formula....
Select " New rule and enter Select which format you want and you're done

If you are not familiar with the SUMPRODUCT function read this link


HTH

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post