Conditional Formatting - Report

kelly Bumpus

I have set up a conditional formatting rule that is certain values are out of range, the cell is highlighted red. I'm having trouble setting up a report that only displays the rows that are highlighted red. I've tried to set up a helper column but can't find a formula that refers to if the cell is a specific color.

Any ideas of alternatives?

Andrée Starå

Hi @kelly Bumpus

Unfortunately, it's not possible at the moment to use the color as a filter in a report, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

As a possible workaround, you could create a so-called helper column that matches the conditional formatting rule and then use that for the report.

Make sense?

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Mike Wilday

As a workaround, you can use the parameters for your conditional formatting to flag your row and then you could report on that flag?