Google Sheets | Dynamic Master sheet that grabs red formatted cells from another sheet

by Jay   Last Updated June 13, 2019 07:03 AM

Title may be a little too ambiguous but I'll try give a run down as best I can;

I have a Google sheet with multiple "Sheets" or Tabs (as I'd like to call them) within it.

The Main tab is blank and the rest have various cells with different dates on them. The dates that are close turn their respective cells Red. I have existing conditional formatting to do this.

What I want to achieve is the main tab basically checks all the other tabs for any red cells and pops them into the main sheet in a vertical column.

Here's an example:

"Second tab"

  • (A1) Date 1 (green)

  • (A2) Date 2 (red)

  • (A3) Date 3 (red)

  • (A4) Date 4 (Green)

"Main tab"

  • (A1) Date 2 (red)

  • (A2) Date 3 (red)

As you can see, "Main tab" ignores any green cells from "Second tab" and only grabs the red ones. In my case though, there are many more tabs, not just 1.

I have a feeling "=IMPORTRANGE" may help in this scenario? Maybe.

Any help is greatly appreciated!



Related Questions


Updated April 14, 2019 20:03 PM

Updated March 28, 2019 15:03 PM

Updated March 08, 2019 10:03 AM

Updated July 21, 2018 22:03 PM