Admittedly, I am very POOR at CASE statements. In the example below here's my objective.
When the workbook change event is triggered I would like to evaluate which cell generated the change. In the view below cells O6:O9 a function is entered in each cell independently. I have cells Q6:R9 formatted as ";;;". When a function, for example, in cell O6 has been enter I would like to change the formatting for range Q6:R6 set to "General". The same would apply for O7, O8 and O9 and their corresponding ranges Q7:R7, Q8:R8, and Q9:R9. Would a Case statement be the best way to handle this and what would be the code, please.