Color Cells Automatically..

**newbie1234** · 12-28-2008, 02:48 AM

Hi guys,

I have this scenario which i need to automate it. I have 5 colums P1,P2,P3,P4,P5. It contains W or L combinations.

In my Column F i Concatenate(A2,B2,C2,D2) together and it follows on for the rest.

Now i have some criteria which i am going to search in my Column G. In Cell I1 i will list my combination to search. It can be as follows :

WWWW
LLLL
WWW
LLL

So what i need to do is search my F column for this possible match. If it is a match I need to color the my Player 1 to Player 5 for that match. I have shown in my example inside the excel. I know the formula for how to find for matches using my combination. But i got no idea on how i can color it with the respective colors automatically.

Yellow = all four W
Red= all four L
Green= will have 3 W and one L
Blue = have three L and one W

Will really appreciate if someone can help me out with this..

**Leith Ross** · 12-28-2008, 03:12 AM

Hello newbie1234,

Which cells are to be colored? The matching cells in column "F"?

Sincerely,
Leith Ross

**newbie1234** · 12-28-2008, 03:23 AM

Originally Posted by Leith Ross

Hello newbie1234,

Which cells are to be colored? The matching cells in column "F"?

Sincerely,
Leith Ross

If there is a match in column F.. You need to color that row Cells (A,B,C,D,E).

I have stated in my example on the top of my excel how it should be colored..

Thanks alot

**Leith Ross** · 12-28-2008, 04:23 AM

Hello newbie1234,

Sorry for delay. My cats were wanting to play with the computer cables. It's late and they're bored. Anyway, the following macro is attached to a button on "Sheet1". Click this and it color the rows that match what is in "I1", i.e. the "WWWW", "LLLL", "WWW", and "LLL" combinations.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

**newbie1234** · 12-28-2008, 04:35 AM

Thank you so much Leith for you help..

I tried running the Macro it works.. But i face 1 problem.. When i Enter WWWW and Hit the button it will color the cells accordingly. But when i enter LLLL combination and hit the button there isnt any action?

How can i rectify this issue..?

Thanks

**newbie1234** · 12-28-2008, 05:18 AM

Originally Posted by newbie1234

Thank you so much Leith for you help..

I tried running the Macro it works.. But i face 1 problem.. When i Enter WWWW and Hit the button it will color the cells accordingly. But when i enter LLLL combination and hit the button there isnt any action?

How can i rectify this issue..?

Thanks

Problem Solved..Thanks Leith for helping out..

Color Cells Automatically..

LinkBack

Thread Tools

Rate This Thread

Display

Color Cells Automatically..

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions