My question is on conditional formatting based on values in a particular cell.
So let's say I make a form, and when users fill out the form, the answers will auto-populate in my spreadsheet.
Column A: "Incorrect 4th party calls"
Column B: "Incorrect cache-busting"
Can spreadsheets "know" that if cell A1 has phrase "Incorrect 4th party calls," it will assign a score in a new column (C)? For example, can we make it so that the existence of the phrase will assign a corresponding score in column C? In the same way, if cell B3 has the phrase "Incorrect cache-busting," can we make it so that the phrase can trigger a score in column D? Another option is whether spreadsheets can "know" that a value has been inputted into cell A1, and because there is a value, able to assign a score in C1?
Put the following formula in Cell C1 to check whether "Incorrect 4th party calls" exists or not:
=ArrayFormula(if(A:A="";"";(if(A:A="Incorrect 4th party calls";"entry exists";"entry doesn't exists"))))
OR put the following formula to calculate score in Cell C1, it will count no. of times "Incorrect 4th party calls" exists in Column A:
=Countif(A:A;"Incorrect 4th party calls")
I hope the above solution will help you, and if you need more help then please do comment below on this blog itself, I will try to help you out.