I want to run a report that pulls data from several different project schedules and tie them together into a overall calendar. Is there anyway to add formatting to a report or to have a sheet mirror the information that is run on the port? I need to either
A: Be able to format the calendar on the report(I know that reports take conditional formatting from other Sheets, Would I have to format the calendar on every sheet to meet my needs on the report that is run?) or
B: Create a sheet that can mirror the information on the report and update as the report is run/changed. Copy and Pasting the information is not ideal since I may want to see a different view for specific date ranges or projects etc.