Conditional format between two cells

[jk]

I have two columns D2 &E2 which one is for received date and the other for
due date. What would be the formula to compare if one date is greater than
the other date by 90 days? I have tried cell is and formula is between the
two dates in the columns but it does not come out.....what am i doing wrong

 

[Dave Peterson]

=if(d2-e2>90, ...
=if(e2-d2>90, ...
or
=if(abs(e2-d2)>90, ...

Depending one what you mean.

 

[jk]

Thanks Dave,
How about if i just need to have cell d2 highlight if the date is greater
than todays date?

 

[Dave Peterson]

=d2>today()
(For format|conditional formatting???)

or

=if(d2>today(),"it is","nope")

 

[jk]

I have entered into conditional formatting:
=d2>today()>90 with the highlight of yellow if condition true then i entered
the date 01/01/2006 into the cell but nothing happens.This formula was
entered into the first condition as formula is.....What could i being doing
wrong?

 

[Dave Peterson]

=d2>today()-90

or some variation????

I have entered into conditional formatting:
=d2>today()>90 with the highlight of yellow if condition true then i entered
the date 01/01/2006 into the cell but nothing happens.This formula was
entered into the first condition as formula is.....What could i being doing
wrong?