In a range of cells starting with cell E46:
The formula, =TODAY()-E46>365, works to format dates greater than 365 days.
The formula, =ISTEXT(E46), works to format text.
The problem: how to combine these formulae to format cells in the range with dates > 365 days, AND cells with text. If a cell has a date > 365 days and a different cell has text, they both would be formatted.
Bookmarks