Google Sheet Formula

Job ID: 30647090

Budget: $15 – $25 USD

Currently, the user is choosing the objective on a drop-down and I'm manually typing the CPM. What you need to do is formulate the CPM based on the chosen objective's predefined CPM. Add $2 on CPM if a column says yes.

Conditional formatting for Gross Cost and CPM, if CPM is $28 above, gross cost should be equal to or greater than $15k

Please send related sample Google sheet works.