Forum Discussion
IF AND function
I have two columns on my excel, one is to show the Task Due Dates and other one to show the Actual Completion Dates. If I were to add the third column to show "Late" if the Task Completion column dat...
Hi,
You may use conditional formatting https://support.office.com/en-us/article/Use-formulas-with-conditional-formatting-fed60dfa-1d3f-4e13-9ecb-f1951ff89d7f to highlight such cells/rows.
If third column the formula could be
=IF(Task Completion Date > Actual Completion Date,"Late","")
Thank you. it helped. :)