Feb 11 2022 10:55 AM
Hello! Does anyone know if there is a way to conditionally format data points in excel to automatically change color based on 1) a date listed on that row, and 2) that is also greater than a specific value? To be more specific, I work in a lab, and test results for multiple tests taken on the same day are listed across a row. The date is listed in column 1. I need the color change to happen when the results are greater than or equal to a specific number, but that specific number is different in the winter months than in the summer months. So I would need to be able to specify that if the date in column 1 is between the months of May through October, then the color change needs to happen greater than or equal to X, but in the months of November through April, the color change needs to happen greater than or equal to Y. This is maybe confusing sounding, but I'm hoping someone can help!
Feb 11 2022 11:16 AM
Maybe as shown in the attached file. You can dynamically enter X and Y in cells K2 and L2.
Feb 11 2022 11:20 AM
Feb 11 2022 11:29 AM
Okay so here is what I'm talking about. So under the column entitled NH3-N, there are the results from specific dates (all samples taken on the same date are in a row). The allow limits are listed above, so in the winter, I need the color change at greater than or equal to 1.4, but in the summer I need the color change at greater than or equal to 1.3. But ONLY for the results listed in that one column. I just don't know how I would actually write that rule.... (I absolutely appreciate the help, by the way!)
Feb 11 2022 01:07 PM
SolutionMaybe as shown in the attached file.
Feb 14 2022 04:17 AM
Feb 11 2022 01:07 PM
Solution