Forum Discussion
Help on lookup from a list and then display result based on content
Good morning All, I am trying to get Excel to look at a list from column AC and then if the name is in the list and also in column E (inputted from a drop down list) it colours the cell in column...
To which range did you apply the rule? And does it work as desired in file I attached?
I'm sorry, didn't realise you had sent the attachment back - just loaded it and that's working perfectly
thank you so much - been trying to do this for days 🙂