Conditional Formatting using both current and adjacent cells

[Joanne Lyons]

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 cell to compare if it has increased or decreased?

[#2]

Set up Condition as type Format where Formula is true
=IF(E5>D5,TRUE,FALSE)

[#3]

Hi Joanne,

Bit unclear. How do you know when you cell was changed last time? You may use VBA code to keep the history, or your cell is linked with the date within your date structure. Or if you have two cells for this and previous months to compare.