+1 this feature.
I use it for auto-highlighting things that are due at different stages (3 business days out ,versus next day, versus same day, versus overdue). Generally I put this formatting on one column of data (the ‘due date’) so that the sheet ...