I am trying to figure out how to introduce conditional formatting to a range of cells with date values. I want each cell in the range to be highlighted based on whether it is "expired" or not - that is, if the date is older than TODAY().
to highlight a cell in the F column if the date is older than TODAY(), but this didn't seem to work. I'm trying to avoid having to do this to cells individually. Any assistance would be greatly appreciated.