Forum Discussion
Solved
Conditional Formatting in Excel
I have a Status field. I am trying to automatically select an option based on the following: When E10 (Assigned To) is NOT blank AND F10 (Progress) is blank OR 0%, then K10 (Status) should equal "...
How about:
=IF(F10=0%,IF(E10="","Unassigned","Assigned"),IF(F10=100%,"Complete",IF(F10<75%,IF(J10=0,"Behind Schedule",IF(J10<=5,"At Risk","Working")),"Working")))
How about:
=IF(F10=0%,IF(E10="","Unassigned","Assigned"),IF(F10=100%,"Complete",IF(F10<75%,IF(J10=0,"Behind Schedule",IF(J10<=5,"At Risk","Working")),"Working")))
Thank you! That works fine.