I assume you are using Excel 2003:
Select column F and go to Format|Conditional Formatting.
Select Formula Is and then enter formula:
=AND($C2="Completed",OR($F2="",$K2=""))
click Format and choose from Pattern tab.
click Ok.
Now click column N and similarly go to Format|Conditional Formatting, then Formula Is..
=AND($B2="Execute Test Case",N2="")
click Format and choose from Pattern tab.
Bookmarks