Warwick has attended:
Excel Advanced course
Conditonal formatting
How Do I clear conditional formating from a column?
RE: Conditonal formatting
Select the column in question. Go to the Home Ribbon and select conditional formatting. From the dropdown select Clear Rules and select clear rules from Selected Cells.