Hi Goodstart14,

This sounds like you need a CountIf() formula in a Conditional Formatting dialog on sheet 1. If you attach a sample workbook we can deal with a real problem. To attach a sample, click on "Go Advanced" and then the Paper Clip Icon above advanced message area.