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