Hoping someone can assist with the following. Based on the attached sample I need to get cell B12 on the Assessment tool worksheet to indicate Pass or Fail (with conditional formatting of Green or Red) based on the total sum of scores (D12) being equal to or higher then the cut scores on worksheet 'Drop Down Selections' column G.
On the first worksheet referenced there is a drop-down list, B3, to change the job title. So I need the Pass/Fail to work based on the cut score of the job title selected.
If there is a way to indicate the score from the first sheet cell D12 next to the job title in the drop down selection worksheet (column I) that would be great if it can be included.
Any assistance would be greatly appreciated.