I have a column of numbers for every day of the year (365 entries). These number represent a Quality Control number. I already have a cell to calculate the average of the total population of numbers. At the moment I have each cell conditionally formatted to highlight the cell red if the number in each cell is 10% over or under the mean average.
The problem I am having right now is that as the value of the QC changes over the year, it is retroactively applying that conditional formatting prior values, and I don't want it to do that. I don't want to retroactively change numbers that were once within parameters.
Thanks
Bookmarks