Excel
Conditional highlighting with functions
This is a collection of frequently used functions for conditional highlighting in Excel.
Highlight cells that are formatted dates and the dates are older than X days:
=IF(LEFT(CELL("format",A1),1)="D",IF(A1<TODAY()-37,TRUE,FALSE),FALSE)
:end