| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional format cells with formula | Excel Worksheet Functions | |||
| Conditional format for cells. | New Users to Excel | |||
| Conditional Format based on 3 other cells. | Excel Discussion (Misc queries) | |||
| Conditional format to colour cells | Excel Discussion (Misc queries) | |||
| Conditional Format Cells containing formula | Excel Programming | |||
Linear Mode
