Excel 2007 – Conditional Formatting

Hi everybody,

I have a question in Excel 2007 about the conditional formatting.

I have a table and this table has 1 column per day for a given month. (from 1 to 31 for the month of March)

There is 40 rows.

What I want to do is change the formatting of a cell if it’s value is bigger than the cell on it’s left (the day before) and I want to do that for every cell, for every day.

I also want to do a different formatting if the value is smaller.

I tried with conditional formatting but I think I’ll need VBA to achieve this, I tried but I’m not very good in it, any of you could give me some help please?

Regards,

Gabriel