Conditional Formatting on Sort

Question

Hello,

I'm wondering how the following conditional formatting scenarios can be achieved. I am looking at a document comment report for different documents (with different "document IDs"). Each document can have multiple comment threads, which all have the same "thread ID"

1. Highlighting the latest comment in a thread, e.g. the comment with the most recent date in the "modified date" column for each thread ID.

2. In a separate Excel worksheet tab, turning each "document ID" green if all comments have been marked "resolved" in the status column.

Also, I want this conditional formatting to export to the Excel report.

Thank you!

Comment Report Example.xlsx

ddiesel · Accepted Answer

Hi @Nageeen

Not sure if this is the most elegant solution, but I think this will get you close.

I added an example 3 to show a document name where all the comments are not resolved.

Let us know if this works for you!

ddiesel · Accepted Answer

Hi @Nageeen

Glad it worked for you!

Here is one way to render the two sheets to the same document:

The formula tools create the sheet names and give you something to group on. Tables can be combined with the Union tool. Then the Layout Tool allows you to design the layout and section by sheet name.

Let us know if this works for you and good luck!