Return to Revisions

You don't need IMPORTRANGE. Also, you can't have a formula that checks only for color (you would need a script or addon for that). However, you mention that you already have conditional formatting rules in place that already do their job to turn cells red so you can gain an advantage of it and use the same rules in your Main sheet (but not as CF) to get data you need.