Thanks in advance...

I am trying to keep track of sales by day for multiple stores. Columns are days (dates) and rows are multiple locations. Each day I log in the sales.

I would like the data that is entered to be GREEN if the amount I enter is greater than the previous days sales and RED if less (ie if D6>C6, then green, if D6<C6, then Red). This way I can easily see the trend, instead of mentally figuring out if its higher or lower.

Any ideas??