Hello All,
I'm trying to set up conditional formatting where colors change based on how many days they are away from an automatically generated reference date (Helper Column).
Currently I have it set up so that in when the reference date is in 15 days, the "date certified" column will turn yellow, in 5 days it will turn red, and if it is past due it will turn black. I would like it so that if the date certified is Blank then the formatting for 15 days and 5 days will trigger, but if anything ends up in the black it needs to stay black no matter what. From what I can tell, I did everything correctly but it seems to be hit or miss when I input test dates to see the formatting. Any guidance would be greatly appreciated!
