Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Excel Formula Help

Options
  • 05-07-2013 1:56pm
    #1
    Soby
    Registered Users Posts: 5,977 ✭✭✭


    Hi,

    Basically what I'm looking to do is. If the numbers are on sheet one ( picture 1 below) then the 3rd box of that number of sheet 2 gets coloured in automatically (like picture 3).

    Have very little Excel knowledge except from what I've gotten through Google. So i expect its some form of a IF statement just not sure what :P.

    Any help be great :)

    Thanks

    Picture 1 (Sheet 1)

    Picture 2 (Sheet 2)

    Picture 3 (Sheet 2) - What it would look like with forumla


Comments

  • Options
    #2
    jabberwock
    Registered Users Posts: 928 ✭✭✭jabberwock


    can do it with conditional formatting.

    probably other ways but I'm just out of bed and this works.

    it will take 5 numbers on sheet 1


Advertisement