Select the cells you want - go to "FORMAT" and select "CONDITIONAL FORMATING" and start answering the questions, for the various conditions you want.