Get whole rows from another sheet with color coding.

**nilsen123** · 03-09-2019, 08:10 AM

Hello.

I want to be able to get information in a row from one sheet to another one with the color coding.
In sheet1 I have football teams follow by their opponents the coming weeks. For example B3 are the team name and D3, E3, F3 etc. are their opponents. I the whole row of opponents to appear in sheet2 with the color coding, when I type in the team name. I tried using a complex IF-function, but wasn't able to get the whole row or the color coding, only one column at a time.

Apparently I am not able to post links or images, so can't post my example

**BadlySpelledBuoy** · 03-09-2019, 08:16 AM

Hi and welcome.

Might be quicker and easier to help you out if you can attach a sample workbook showing your before and after.

To attach a sample workbook click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Should all make sense from there.

BSB

**nilsen123** · 03-09-2019, 08:26 AM

I have uploaded the attachments, but the forum is telling me that I'm not allowed to post any kinds of links, images or videos until I post a few times.

**BadlySpelledBuoy** · 03-09-2019, 08:30 AM

As far as I'm aware there isn't a post count requirement for attaching files if you follow the method I mention above. The paperclip icon won't work.
We don't want a link to the file or a picture of it so don't worry about those.
Click "Go Advanced" below your reply then "Manage Attachments" a little further down. That will open up a window where you can attach the file.

BSB