@Mike ,
It’s absolutely doable. I recently worked through a similar case, where we were conditionally formatting based on comparison of current value with previous week’s value.
Conditional formatting in matrix comparing value with last column with data
I hope this is helpful.
- Brian