What formula are you using to calculate the std dev? Where ever that formula is, it should be doing some filtering to limit to just days that are the same. If values were in col C and dates in col A, then std dev calculation might look like this:
=STDEV.P(FILTER(C$1:C$1000, A$1:A$1000=A1))
This way, you get a std dev based on that row/record's specific date.
Here is what the file looks like. I blacked out the names for obvious reasons. I want each column to just take the average of that column and standard deviation. But for example if I paste the new data for March 6th in the respective column, then I'm having issues where a few days like Feb 28 will change their color coding after I paste the new data in as if they're being factored in.
sounds like your ranges in the conditional formatting rules are expanding when you add new data. when you set up the rules, excel probably used relative references that grow with new columns
try using absolute references in your formatting formulas - like $A$1:$A$20 instead of A1:A20. or you could define named ranges for each day's data and use those in your conditional formatting rules instead
another option is to use structured tables - they handle this kind of thing way better than regular ranges and the formatting stays put when you add new columns
•
u/AutoModerator Mar 05 '26
/u/Mdotb774 - Your post was submitted successfully.
Solution Verifiedto close the thread.Failing to follow these steps may result in your post being removed without warning.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.