Maybe it's because it's soo late and I'm here working on this but I can't figure this out. Help from the masters would be appreciated.
I have a conditional formatting formula already setup and it works...
<date(2019,8,2)))
AND(($AZ10>0.249),($F10<date(2019,8,2)))
<DATE(2019,8,2)))...