Dashboards don't updated based on conditional formatting of cell

Options

I have a sheet with a value that I have applied a conditional format to (if negative change to red text). This cell is then linked in a dashboard that I use. The sheet's value follows the formatting rule accurately but the Dashboard matches the value but NOT the format. Is there something I am missing with my linking? Is there a way to conditionally format a Dashboard widget value?

Thanks for any feedback.

Answers

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭
    Options

    I don't think that's possible. You can embed a report which does contain the conditional formatting from the original sheets. This would allow you to display the red rows to your key stakeholders, presenting the information and formatting it correctly. Would that work?

    I would also submit a product enhancement request as this would be a GREAT feature.