Conditional Formatting using both current and adjacent cells

Hi,    I am trying to colour code a spreadsheet to show if the cell has increased or decreased since last month. How to I first get the cell to look up the correct name and then look at the correct...