Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Excel formula question

  • 15-11-2019 11:54AM
    #1
    Poncke
    Registered Users, Registered Users 2 Posts: 956 ✭✭✭


    I have 3 cells, each cell has a value, 1, 2, 3

    The cell value is related to a score, each score located in another cell, 10, 8, 0

    To pick a value, the user has to change the cell fill colour

    Then the formula needs to pull in the score of 10 into another cell.If the User picks the cell with number 2 and fills it with a colour, then the formula needs to pull in 8 into the cell, etc.

    How do I do this?

    Thank you

    PS: This probably need a VBA code, which is fine. Its like a Vloopuk for the cell that has no white/blank fill.


Comments

  • #2
    Poncke
    Registered Users, Registered Users 2 Posts: 956 ✭✭✭Poncke


    I have it all sorted now with a workaround. I created an UDF to use in a formula to copy the value of the coloured cell into another cell, and based on that cell, I did a vlookup. I got what I want now.


Advertisement