Having to open each source sheet to have the conditional formatting update is not efficient.
The refresh on reports and dashboards do not update the conditional formatting for each row.
Every single sheet must be opened every day for them to display the correct colors (ex: 3 days away - blue, 1 day away - purple).
I log on and something "3 days overdue - red" is still showing "3 days away - blue", when I click the source sheet it quickly shows the wrong color then updates to the new color.
When I go back to the report, the row displays correctly - in this example it would show 3 days overdue - red color (rather than the incorrect: 3 days away - blue color, that had be displayed on the report before opened that single source sheet).
NEED A WAY TO APPLY CONIDITONAL FORMATTING TO REPORTS
NEED A WAY TO REFRESH ALL SOURCE SHEETS AT ONCE (so the reports and dashboards will have truly updated information from source sheets without having to manually open each one)