ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Past Due/Completed on time date formula (https://www.excelbanter.com/excel-discussion-misc-queries/191015-past-due-completed-time-date-formula.html)

stacy

Past Due/Completed on time date formula
 
I am pretty familiar with Excel, but just learning formulas...

I have two columns I am working with for this question, a due date and
completed date.

I used the formula =A1<=today() to highlight a "past due" date red. I was
wondering if in my completed date column I could enter a formula that would
highlght a date Red if it was past the date, or blue if it is bofore the due
date.

Also, will this update as I work with it, or only as I enter in cells?

Thanks for your help!

Sean Timmons

Past Due/Completed on time date formula
 
almost the same as you have below. In the first completed date, use
Conditional formatting with =$A1=$B1 and format as Blue, then =$A1<$B1 and
format as red as a second criteria. Then copy and Past Special - Formats.

"Stacy" wrote:

I am pretty familiar with Excel, but just learning formulas...

I have two columns I am working with for this question, a due date and
completed date.

I used the formula =A1<=today() to highlight a "past due" date red. I was
wondering if in my completed date column I could enter a formula that would
highlght a date Red if it was past the date, or blue if it is bofore the due
date.

Also, will this update as I work with it, or only as I enter in cells?

Thanks for your help!


stacy

Past Due/Completed on time date formula
 
Thanks Sean, this worked great.

I have another question though. Will this update when I open my doc? Will
it recognize today is changing?

Thanks again!

"Sean Timmons" wrote:

almost the same as you have below. In the first completed date, use
Conditional formatting with =$A1=$B1 and format as Blue, then =$A1<$B1 and
format as red as a second criteria. Then copy and Past Special - Formats.

"Stacy" wrote:

I am pretty familiar with Excel, but just learning formulas...

I have two columns I am working with for this question, a due date and
completed date.

I used the formula =A1<=today() to highlight a "past due" date red. I was
wondering if in my completed date column I could enter a formula that would
highlght a date Red if it was past the date, or blue if it is bofore the due
date.

Also, will this update as I work with it, or only as I enter in cells?

Thanks for your help!


Sean Timmons

Past Due/Completed on time date formula
 
Yes, the day will change instantly. If you happen to be there at midnight,
you should see the information change while you watch.

"Stacy" wrote:

Thanks Sean, this worked great.

I have another question though. Will this update when I open my doc? Will
it recognize today is changing?

Thanks again!

"Sean Timmons" wrote:

almost the same as you have below. In the first completed date, use
Conditional formatting with =$A1=$B1 and format as Blue, then =$A1<$B1 and
format as red as a second criteria. Then copy and Past Special - Formats.

"Stacy" wrote:

I am pretty familiar with Excel, but just learning formulas...

I have two columns I am working with for this question, a due date and
completed date.

I used the formula =A1<=today() to highlight a "past due" date red. I was
wondering if in my completed date column I could enter a formula that would
highlght a date Red if it was past the date, or blue if it is bofore the due
date.

Also, will this update as I work with it, or only as I enter in cells?

Thanks for your help!



All times are GMT +1. The time now is 08:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com