Dynamic Chart

ejacksonBPT

I'm trying to create a dynamic chart that shows a number count for the past three months.

I figured I could set conditional formatting to change the font or row color based on the date but is there a way to pull (only those with the color) into a metric sheet to create a graph?

Or any other way going about that?

Paul Newcome

You won't be able to look at formatting using a formula or filter. You could create a filter on a report though that mimics your conditional formatting rule.

Paul Newcome

You won't be able to look at formatting using a formula or filter. You could create a filter on a report though that mimics your conditional formatting rule.