Xcel Workbook to manipulate cells based on percentages

Each day I review sales figures for my company. I import the data into an Access database which in return gives a number count of how many sales a product has made on that day. For instance, Flagpole 230, stop sign 1300, etc. I enter the product sales of everything we sell into a spreadsheet for that day. Each row is represented by the product and I have dates in each cell underneath with the total sold for that day.
Im not a programmer, but have an idea that seems logical for my spreadsheet. I have about 6 months worth of data in the spreadsheet. I decided to put this in steps as it will be easier to ask the question.

"      For all the data in the row, I would like to be able to create an average based on the previous days data.
"      After an average is determined, I would like to use this number to influence new data
"      After the days sales for a product is entered, if the number is higher or lower than the baseline average, the cell will turn a color
For example, excel will use the formula from the first step to get an average sold number for a product. Lets say, for all the previous days data, a flagpole sells on average 215. When I input the data for todays day and the number is greater than 215, I would like the cell to turn green. If the data in the cell is below 215, I would like it turn red.

This way, I can know how the days figures rank in real time. I attached a basic spreadsheet to visualize my idea. The 6/4 example would represent that days data.
Start Free Trial