View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Conditional format between two cells

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

Depending one what you mean.

jk wrote:

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