Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formating dates, please help me
Sorry but this is a multiple part question. The spreadsheet in question is a
tracker for incoming tasks. column D is the received date(dd-mmm-yy). I want to highlight the new tasks received with in the last 72hrs. so basically equal to or 72 hrs less than todays date. Column E list the due date(dd-mmm-yy). I would like to highlight the cell that are due in the next 7 days red and 8-30 days amber. Column K shows the status as "complete" or "in progress". it is already conditionally formated to highlight green when "complete" is entered and yellow when "in progress" is entered. I need to remove the formating in column D and E above when "complete" is entered in K. I think the first two parts deal with the "=today or =now" function but I cant seem to get it right. thanks mike |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formating dates, please help me
D2: =AND(K2<"complete",D2=TODAY()-3)
E2: =AND(K2<"complete",E2=TODAY(),E2<=TODAY()+7) .... red =AND(K2<"complete",E2TODAY()+7,E2<=TODAY()+30) .... amber HTH Bob "mike" wrote in message ... Sorry but this is a multiple part question. The spreadsheet in question is a tracker for incoming tasks. column D is the received date(dd-mmm-yy). I want to highlight the new tasks received with in the last 72hrs. so basically equal to or 72 hrs less than todays date. Column E list the due date(dd-mmm-yy). I would like to highlight the cell that are due in the next 7 days red and 8-30 days amber. Column K shows the status as "complete" or "in progress". it is already conditionally formated to highlight green when "complete" is entered and yellow when "in progress" is entered. I need to remove the formating in column D and E above when "complete" is entered in K. I think the first two parts deal with the "=today or =now" function but I cant seem to get it right. thanks mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formating on dates | Excel Discussion (Misc queries) | |||
i need help with conditional formating with dates | New Users to Excel | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
conditional formating: dates | Excel Worksheet Functions | |||
CONDITIONAL FORMATING DATES | Excel Discussion (Misc queries) |