Need help automating my sheet

[Nebul0us]

I need help automating this sheet. I want to highlight the winning team on the left, then have the losing teams automatically highlighted for every person. After that I want the total highlighted cells to be counted and output at the bottom for each person. Please see my example I hope I made sense....

 

[Joe4]

Hello and welcome to the Board!

Obviously, your question does not make sense without seeing any data.

You cannot upload files to this site. But there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html. Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.

 

[Nebul0us]

Hello and welcome to the Board!

Obviously, your question does not make sense without seeing any data.

You cannot upload files to this site. But there are tools you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html. Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.

Are you not able to see the pic in my post?

 

[Joe4]

Are you not able to see the pic in my post?

I don't see anything there, do you?

 

[Fluff]

I don't see anything there, do you?

Hi Joe
I can

 

[Joe4]

Hi Joe
I can

Interesting. I am using Chrome, and do not see anything. In IE, I see a little black box with an X in it. I wonder if it is being blocked by Corporate Security policies.

NebulOus,
Can you tell us how you posted the image? I want to understand which method of posting images is problematic.

 

[Fluff]

For those that can't see the image look here
https://i.imgur.com/3Spxs2Z.jpg

I suspect its a CF solution, but not something I can help with

 

[Joe4]

For those that can't see the image look here
https://i.imgur.com/3Spxs2Z.jpg

I suspect its a CF solution, but not something I can help with

Unfortunately, those sites are blocked for me (for the same Corporate Security Policy I mentioned earlier...)

That is why we usually recommend the tools included in my link - the maximum number of users will be able to see it. Otherwise, you may be limiting your pool of potential helpers.

 

[Fluff]

@Joe4
I can see the image in Firefox, & IE10

 

[Joe4]

I am using Chrome and IE11, and cannot.
So I suspect it is my Corporate Security Policy.