Is there a solution for a report to auto update the conditional formatting without opening the sheet.
Forexample. We have a report showing on the dashboard. When the due date is in the past we have conditional formatting making that row turn red.
Even if we click into the report it doesn't go red until we open the sheet.
Am I missing something on why the conditional formatting doesn't update on a report until someone goes into the sheet.
