Related to earlier question can you use conditional formatting to look at two columns rather than 1.
In the attached example, column E is being formatted based on the contents of column D and checking dates.
Can this formatting be changed so that if there is no text in the cell in Column D, it looks at the cell in Column C instead.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data.
Rather than update each graph to point to a different set within a static set of data, t…