I have a file were each row coresponds with food choices from the catering firm, for a certain employee , and on the same row in BR3 there is the calculated total ammount based on the food they choose in the cells (D3: BQ3).
I want a pop up message to be displayed if the value calculated in BR3 is greater than 116.
Also i want to replicate this pop up for each row in the table so the range of cells, were the formula with total ammount is , will be B3:B67.
I tried data validation by choosing Allow: Whole number->Greater than->Minimum:116 or Custom -> Formula:BR3>116
Also if this works i whant to protect from editing the cells that calculate the total ammount, if this information is helpful in a vba code.