"Sheet Name" column for Sheet

Question

I have a report that pulls data from multiple sheets.  Sometimes I want to know what sheet the data came from.  The Sheet Name column on the report provides the name of the sheet from which the data was drawn.  However, due to the formatting of the Sheet Name column, it's not easy to spot when data comes from certain sheets because they all look the same.  I'd like to add color to make it easier to do this.  Is there a way to see (or add) a "Sheet Name" column to the actual parent sheets themselves?  Then I could shade the column blue on one sheet, green on another sheet, etc., and have that formatting show up in the Sheet Name column on the report.  Then I could look for which ever color I want.

I know I could do this through sorting, filtering, and grouping, but I don't want to destroy the current configuration I have for those things already established to accomplish this temporarily.  It's a pain to change those and then have to change them all back.

amarkumar · Accepted Answer

@jtallman You can’t, but you can add a helper column in each source sheet (e.g., Source/Team) with a fixed value, then apply conditional formatting in the report based on that column.

Paul Newcome · Accepted Answer

@amarkumar Please check your source(s) before posting. Conditional formatting is not available in reports.

Paul Newcome · Accepted Answer

@jtallman After applying the helper column to each sheet, you would need to also implement any formatting within the sheet as well.