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...
Thank you for the reply. I applied the conditional format rule but the cells do not go red if the name is in column AC
I wasn't sure what you meant by As for the text in cell that's by formula, not by conditional formatting. If to add, when one more condition for the formula.
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 🙂