Pulling colored cells (some with conditional and non conditional formatting) into a new sheet

%3CLINGO-SUB%20id%3D%22lingo-sub-2038378%22%20slang%3D%22en-US%22%3EPulling%20colored%20cells%20(some%20with%20conditional%20and%20non%20conditional%20formatting)%20into%20a%20new%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2038378%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20template%20that%20has%20a%20report%20and%20some%20formulas%20to%20pull%20from%20other%20sheets%20that%20in%20the%20end%20do%20a%20conditional%20color%20for%20those%20that%20pull%20as%20true.%20I%20will%20color%20other%20cells%20in%20the%20same%20line%20to%20make%20it%20easier%20to%20see%20what%20days%20are%20true.%20with%20this%2C%20I%20need%20to%20pull%20the%20cells%20that%20are%20colored%20from%20this%20report%20and%20have%20the%20information%20entered%20onto%20a%20new%20sheet.%3C%2FP%3E%3CP%3EBelow%3B%20Left%20side%20I%20manually%20colored%20Right%20side%20has%20the%20conditional%20formatting%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Melissa1234_1-1609974409752.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F244620iB60224212FBD1356%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Melissa1234_1-1609974409752.png%22%20alt%3D%22Melissa1234_1-1609974409752.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20cells%20that%20are%20on%20the%20report%20in%20yellow%20I%20need%20pulled%20and%20entered%20on%20the%20new%20sheet.%20Here%20is%20the%20layout%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Melissa1234_2-1609974450755.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F244621i501CE40AE7FC5C6C%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Melissa1234_2-1609974450755.png%22%20alt%3D%22Melissa1234_2-1609974450755.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20been%20looking%20at%20a%20bunch%20of%20different%20post%20online%20about%20macros%20etc%20but%20having%20issues%20getting%20what%20I%20need%20because%20I%20have%20conditional%20and%20unconditional%20cells%20I%20need%20to%20pull.%20Any%20help%20is%20very%20much%20appreciated%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2038378%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2041665%22%20slang%3D%22en-US%22%3ERe%3A%20Pulling%20colored%20cells%20(some%20with%20conditional%20and%20non%20conditional%20formatting)%20into%20a%20new%20sheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2041665%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F920427%22%20target%3D%22_blank%22%3E%40Melissa1234%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EImages%20are%20far%20less%20helpful%20than%20actual%20spreadsheets.%20Is%20it%20possible%20for%20you%20to%20take%20any%20real%20names%20and%20IDs%20out%20of%20these%2C%20substituting%20made%20up%20names%20and%20leaving%20some%20real%20representative%20data%20in%20them%2C...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20entirely%20possible%20that%20what%20you're%20trying%20to%20do%20is%20relatively%20easy%2C%20not%20involving%20a%20need%20for%20macros%2C%20but%20it's%20simply%20a%20lot%20easier%20for%20us%20to%20help%20you%20if%20you%20post%20a%20copy%20of%20the%20real%20thing%20with%20some%20representative%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a template that has a report and some formulas to pull from other sheets that in the end do a conditional color for those that pull as true. I will color other cells in the same line to make it easier to see what days are true. with this, I need to pull the cells that are colored from this report and have the information entered onto a new sheet.

Below; Left side I manually colored Right side has the conditional formatting

Melissa1234_1-1609974409752.png

 

Any cells that are on the report in yellow I need pulled and entered on the new sheet. Here is the layout

Melissa1234_2-1609974450755.png

 

I have been looking at a bunch of different post online about macros etc but having issues getting what I need because I have conditional and unconditional cells I need to pull. Any help is very much appreciated 

 

1 Reply

@Melissa1234 

 

Images are far less helpful than actual spreadsheets. Is it possible for you to take any real names and IDs out of these, substituting made up names and leaving some real representative data in them,...

 

It's entirely possible that what you're trying to do is relatively easy, not involving a need for macros, but it's simply a lot easier for us to help you if you post a copy of the real thing with some representative data.