Solved Conditional formatting in excel

March 23, 2016 at 06:11:21
Specs: Windows 7
In column A of Excel i have Due date and actual completion date in Column B

what i am looking for is for the formula where

if actual completion date is on or before due date I need "completed" in column C

if completion date is greater than due date then " delayed completion"

if completion date is blank not completed

See More: Conditional formatting in excel

Report •

March 23, 2016 at 12:38:03
You do not need Conditional Formatting for this, just a formula.

With your data like this:

         A               B                 C
1)  Due Date     Completion Date         Status
2) 03/20/2016      03/23/2016	   Delayed Completion
3) 03/20/2016      03/20/2016      Completed
4) 03/20/2016                      Not Completed

Put this formula in cell C2 and drag down:

=IF($B2>$A2,"Delayed Completion",IF($B2="","Not Completed","Completed"))

See how that works for you.

Also, Excel questions are best asked in the Office Software forum.


message edited by mmcconaghy

Report •

March 23, 2016 at 13:41:39
✔ Best Answer
Here is an updated version, just in case both A2 & B2 are blank
or A2 is blank but B2 has a date.

=IF(AND(A2="",B2=""),"",IF(AND(A2="",B2<>""),"Due Date Missing!",IF($B2>$A2,"Delayed Completion",IF($B2="","Not Completed","Completed"))))


message edited by mmcconaghy

Report •

March 24, 2016 at 04:46:25
thank you very much. it worked

Report •

Related Solutions

Ask Question