Conditional format when min in subset excluding some rows

Hi. I am trying to make a To Do list with conditional formatting, mainly to learn more about how excel works than for any practical purpose. My list consists of an indefinite number of rows and 5 columns titled; Task, Subtask, Priority, Date, and Complete which are in positions A-E respectively.

If my task were to cook dinner I might have 4 rows with that task and subtasks might then be; go shopping, preheat oven, cook meat, cook veggies. (See attachment)

I already have colours working with the conditional format: Row turns green when Done is not empty. Row turns Yellow if task isn't done and is due today (as per Date). Row turns Red if it is overdue (as per Date). The final thing I want to do is bold the text in the highest (lowest number) priority subtask for each task that hasn't been completed yet. In the case of the attached example Preheat oven should be bold.

Currently I am using:

Please Login or Register  to view this content.

which is close to doing what I want. It bolds the subtask with the highest (lowest number) priority if it hasn't been completed but wont then bold the next highest. Eg I have completed subtask A with a priority of 1 I now want subtask B with a priority of 2 to become bold.

Thanks.

You need this as your CF formula, instead:

=$C2=MIN(IF($A2=$A$2:$A$27,IF($E$2:$E$8="",$C$2:$C$27)))

You're welcome.

---

If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.

It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.