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 G red. If the name in column E isn't in column AC then I would like the cell in column G to display "No P/O Req"
Also, once something is then put into column G I would like the cell to no longer be red.
We are trying to get our worksheet to display a red cell when a customer requires a purchase order number and not be red when we enter a purchase order number hence leaving a visible guide as to which jobs need purchase order numbers in them.
If anyone can advise the best formula to use for this that would be most appreciated - I have attached the sheet I am using
Thank you
Jim
24 Replies
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
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?
