Results 1 to 6 of 6

Color Cells Automatically..

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-11-2008
    Location
    Malaysia
    MS-Off Ver
    Office for Mac 2016
    Posts
    138

    Color Cells Automatically..

    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..
    Attached Files Attached Files
    Last edited by VBA Noob; 12-28-2008 at 06:37 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1