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?
2 answers Last reply
More about formulas
  1. This topic has been moved from the section Windows 2000/NT to section Applications by Grumpy9117
Ask a new question

Read More

Office Formula Spreadsheet Apps