Hi - I have a few conditional formats in place in my workbook to track dates and status' (see below). I am looking to have excel ignore the bottom 2 conditions if the top condition is true. I tried to use the stop if true function, but could not seem to get it to work. Any suggestions? Basically I want the cell to highlight if the date is upcoming or past due as long as the task is still outstanding. If the task is complete, I do not want to have the dates highlighted. Thanks in advance!