Vba code when cell in range returns a certain value, enter formula in nearby cell

Thanks. I am new to VBA. Cells(c1.Row, "E") makes a lot of sense. What does If Not Intersect mean?

Thanks. Your code worked. I just had to change the last references since they needed to be absolute: Setup Page'!R44C17)-'Setup Page'!R44C19"