Conditional format between two cells
 

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

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

Conditional format between two cells
 

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

"Dave Peterson" wrote:

=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

Conditional format between two cells
 

=d2today()
(For format|conditional formatting???)

or

=if(d2today(),"it is","nope")



jk wrote:

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

"Dave Peterson" wrote:

=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


--

Dave Peterson

Conditional format between two cells
 

I have entered into conditional formatting:
=d2today()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" wrote:

=d2today()
(For format|conditional formatting???)

or

=if(d2today(),"it is","nope")



jk wrote:

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

"Dave Peterson" wrote:

=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


--

Dave Peterson

Conditional format between two cells
 

=d2today()-90

or some variation????

jk wrote:

I have entered into conditional formatting:
=d2today()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" wrote:

=d2today()
(For format|conditional formatting???)

or

=if(d2today(),"it is","nope")



jk wrote:

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

"Dave Peterson" wrote:

=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


--

Dave Peterson


--

Dave Peterson