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! |
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! |
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! |
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