I have a spreadsheet with two columns of figures A1:50 and B1:50. If cell B is less than cell A I want it formatted green, and if cell B is higher than Cell A I want it formatted red. Using Format/Conditional Formatting I can format each cell in turn but surel... Login to read more.