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 ?
That only means the values in columns E and AC are different. Perhaps you have extra spaces in texts or other non-printable characters. Happens quite often if copy / paste from others source, especially from Web. Hard to say without seeing concrete values.
In any case, that's not conditional formatting error, that's data is not cleaned.