As you can see this is close to what I want but I still have some calculation issue in the background expression. If you look at 2021-03-17 column you can see that the total is 85% yet some of the cells at 83% are not in red.
I can't figure out my error so if someone could point it to me that'd be great.
I had the same though as you and that's the first thing I tried but this doesn't work. None of the cells are red when using the same purple expression.
The Total<Date> is there on purpose. The cells are calculated using the date columns and the Station rows but I want to compare that value to a value that is calculated on the date column only. The key word TOTAL would allow me to apply my expression on all the data of my table. Adding <Date> will apply the expression on all my data for each date.