Conditional Formatting Data based on Data in Another Column

[TaanyaP]

Hi, I have to apply conditional formatting to a column in my spreadsheet. The last three columns in my spreadsheet are Course Status, Date Taken, Due Date. I need to apply conditional formatting to the Due date to show past due, coming due, and not yet due based on whether or not the course has been completed. What formula would I use to set the conditions? For instance, L2 shows Completed with M2 showing the date taken and N2 is the due date (which is in the past) so it is showing red font/red cell color. I do not want N2 to have any type of formatting or color. However, L54 shows Not Started with M54 being blank, so N54 is formatted with font and cell color. How do I write the formula so that only the cells that are not completed are actually formatted conditionally?

 

[63falcondude]

See my answer here http://www.mrexcel.com/forum/excel-...ta-based-data-another-column.html#post4615013