I am working on a spreadsheet and need to create a formula so that in the following instances the cell is highlighted:
If the date in cell A <= Today + 180 days AND The date in cell B <=A + 90 days. Then Cell 'A' will be highlighted.
I am not sure if this is possible.
Can anyone offer a solution?
If the date in cell A <= Today + 180 days AND The date in cell B <=A + 90 days. Then Cell 'A' will be highlighted.
I am not sure if this is possible.
Can anyone offer a solution?