Req: 'IF' formula in excel

Hello,
In one of my excel formate below mentioned row/coloums are there,

Disp. Month IPO # IPO Dt Customer Details Job Name PO No. PO DT Inv No. Order Qty Req. Delivery Date Actual Delivery Date Delivery Week Number OTD Disp. Qty Blc Qty Remarks


i have to add one more colour as pending dispatch status, pls help me how do i will get