Macro in execrable

I need a macro written for excel. The excel is used for control charts for Qc data. I need the macro to flag points on the chart when it is out of control. I have criteria/rules that each pout. Must meet