On the OrderForm worksheet, select row 1 → right click and insert a row → enter “Orders Pending” in cell A1 → change font to Arial 12, bold text and select background colour orange → Select cells A1:AH → click merge and centre from alignment section of home tab
On the OrderForm worksheet highlight row G → select conditional formattingfrom home tab in styles group → select highlight cell rules → select between → Enter date 1/1/2015 in first box and in second box enter 1/31/2015 → select red fill
On the OrderForm worksheet highlight rows 2-119 → select custom sortfrom editing section of home tab → sort by date ordered (column G)
Next try sorting based on cell colour → select custom sortfrom editing section of home tab → sort by cell colour → Select Red on top