Forum Discussion
Help on lookup from a list and then display result based on content
As for the conditional formatting you may apply the rule with formula as
As for the text in cell that's by formula, not by conditional formatting. If to add, when one more condition for the formula.
Hi Sergei, When I add in the rest of our data to the accounts tab and then validate the data to the drop down list the function no longer works, do you know why this is?
You mean conditional formatting doesn't work or something else? I added data close to the end, it works. Try to check condition manually at any empty cell
as
It seems to be ok at the top of the sheet but not at the bottom, I tried as you suggested and I get this result
It also doesn't work at the top of the sheet for the second entry of the same name. Does it work for you on yours if you do multiple entries of the same name ?
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 🙂
